Im new to powerbi and ive been looking for this instead of downloading an external software. Your guide is a big help to my challenge ! Thank you so much
Hello, I wanted to ask a question, following the clip Video above, I have created the icon like the video(black triangle for positive and negative value) into a table visualization. I then would like to chane the color for each value(+,-) but I can not see the data lable in format pane, however I can change the color of value when I create it on the card visualization. Could you please suggest about this. Thank you. however
This works only for a Card. Please see the Below video to apply in a table. Conditional Format a Table/Matrix in PowerBI | PowerBI Tutorial ua-cam.com/video/gLSiQp4tZaA/v-deo.html
This tutorial should help. Compare Amount of this Year/Month vs Last Year in PowerBI | PowerBI Tutorial | SamePeriodLastYear ua-cam.com/video/Mx6-1icI_8Y/v-deo.html
@@MITutorials Can I change it year wise if use slicer. Like if I select year 2018 it should be showing the different between 2017 and 2018 . is it possible ?
Add on the Excel file a date column on your file. It can be an unique date like 31/12/2023, for every row that refers to that month data. When you are at Power Bi go to quick measure, click the variance, add the column data to the Date and the column you need to see the variance by month. And its done! I struggled a lot to find this solution, so I hope it helps!
Im new to powerbi and ive been looking for this instead of downloading an external software. Your guide is a big help to my challenge ! Thank you so much
Great video! Some key points were highlighted that I hadn't heard anyone else discuss. Thank you!
Glad it was helpful!
This video helped me implement the Red/Green indicator in my Project. Thank you so much for this video. Your explanation is amazing.
Glad you found it helpful!
@@MITutorials Yes found it very helpful. Thank you 😊
absolutely amazing, this is what i was searching for
Thank you, that was exactly the information I was looking for. ❤
Thank you. Very useful technique and very well explained 👏
Glad it was helpful!
Initially I thought that icon is present in the Power BI shapes, etc., it helped me to clarify things regarding custom KPI which involves DAX
thaks.it's very helpful
Thank you so much. Make my report looks good
Hello, I wanted to ask a question, following the clip Video above, I have created the icon like the video(black triangle for positive and negative value) into a table visualization. I then would like to chane the color for each value(+,-) but I can not see the data lable in format pane, however I can change the color of value when I create it on the card visualization. Could you please suggest about this. Thank you. however
This works only for a Card. Please see the Below video to apply in a table.
Conditional Format a Table/Matrix in PowerBI | PowerBI Tutorial
ua-cam.com/video/gLSiQp4tZaA/v-deo.html
@@MITutorials thank you :)
@@MITutorials I created icon by using condition formatting already. It looks great. Thank you for your informative suggestions.
I would like to ask a question, if I wanted to campare between Jan 2020 vs Jan 2019 how the formular looks like? Thank you.
Here is a video explaining how to achieve this. Let me know if this helps!
ua-cam.com/video/Mx6-1icI_8Y/v-deo.html
@@MITutorials Thank you for your reply, It is very useful.
Thank you
@Mi I need help with Ticker chart , how can I reach out ot you
I cant find Data Label under visual settings
Can you help me build the sales vs LY measure. Which you have shown us here I am getting error..
This tutorial should help.
Compare Amount of this Year/Month vs Last Year in PowerBI | PowerBI Tutorial | SamePeriodLastYear
ua-cam.com/video/Mx6-1icI_8Y/v-deo.html
@@MITutorials Thank You.
@@MITutorials Do you have any video of conditional Column . if you have please share the link.
@@MITutorials Can I change it year wise if use slicer. Like if I select year 2018 it should be showing the different between 2017 and 2018 . is it possible ?
How to change the size of the icon, if i need it smaller?
Call out value > font size
Please help on DAX function to get Latest month (whichever latest in database) - previous month
Add on the Excel file a date column on your file. It can be an unique date like 31/12/2023, for every row that refers to that month data. When you are at Power Bi go to quick measure, click the variance, add the column data to the Date and the column you need to see the variance by month. And its done! I struggled a lot to find this solution, so I hope it helps!