This is gem of a content, just easy way to add colors at the last, since the data is in text format i used conditional formating for giving it a red or green, if it begins with '-' give me red font else green font. Its working well. Only thing is that the dash seperates the % with actual variance also change its color if you are fine with it you can follow this.
This is extremely helpful! I tried using the same method for multiple cards for different KPIs however I got a few different slicers. How can we sync the different slicers?
This is so awesome! What if I was doing the sales of two departments and wanted "vs Last Month" to switch on both departments sales simultaneously with one click?
I am new to PowerBI and found your video always very helpful, thank you! For color formatting, instead of creating this complicated measure and selecting that field when formatting, can we use rules (contains "+" then green, "-" then green)?
Yes you can! I just accomplished this in my dashboard using the following to create a new measure: Color Indicator = IF( CONTAINSTRING([YourDAXMeasure], "+"), "Green", IF( CONTAINSTRING([YourDAXMeasure], "-"), "Red", "DefaultColor" ) )
Thank you for the video. How would I create a whole report of KPI cards on a report? for example imagine an excel sheet where cell has a conditional background and KPI values? is that possible?
Incredible helpful! I work in professional sport and am using this cars visual to score current vs best testing scores! I was wondering if anyone knew an easy way to create a measure that would allow me to see latest score put into a table based on the last completed screening of just the individual in a slicer! I've figured out a way to do this for last screening date inputed into the column but I'm finding issues when the last screening completed by a player isn't the same as the latest date inputed! Any help would be much appreciated 🙏🏼
Hi Fernan, great content: i use it in my KPI dashboards. I have a question: when you add more visuals like the one you showed (Total Sales) how can you combine all the comparison slicers into 1 slicer ie vs Budget, vs Last Year etc. I now get multiple parameter slicers for KPI_01, KPI_02, KPI_03. Hope you can help me out! Thanks in advance!
@@katiawei6817 You can achieve identical result using tabular editor and new card visuals. Write the code into tabular editor and create card visuals just to display values.
Just come across the video and it's exactly what I need for a dashboard reporting on net zero carbon emissions. Is there also a video explaining how to write the measures that you have here?
Hi...this is very helpfull...I try to produce several card as product comparison, however I found difficulties to show the Rank for selected product in the Card. Do you have any solution?
Hi Everyone, I came across a way to overcome powerbi Report server version's shortage on dont have the field parameter function. I just created a new sceario table in the query and dont need to connect to them, then let it equal to a variable, and create another variable to calculate the sum up of the sales in different sceario. Then replace some the KPI _ACT vs BUD formula that the author has taught us, it is dynamic again!!!! Hope that will help if anyone have same problem as I do. Cheers!
KPI Color will not work for me. I get an error related to the comparison parameter. "Column Comparison is part of composite key, but not all columns of the composite key are included in the expression or its dependent expression". I've researched w/o luck. Any ideas? Thanks!
It nice to look in the Dashboard bro... It was more helpful in saving space in the visual bro. But I need small help bro u had change the Color in the KPI here Possible to Change the color only the Percentage bro. if possible can make the video bro
Hi , sir thx a lot for the tutorial , I wish to design the card like you did on the video , but sadly , I have got only POWER BI Version: 2.112.1421.0 64-bit (January 2023) on my pc , so may I have your suggestion of how to do it ?
when using the FORMAT() function, I lose the ability to convert data type and only 'Text' is available. I noticed in this video you do not have the same problem. do you know why this is?
Love the video, but I am getting a strange result. It works as described if the dataset is in the pbix, but if I try to do this with a thin report, the subtitle conditional format won't let me select the field. I have even tried copying across a working one and it breaks in the thin report. I suspect its a bug in the new visual.
Your videos have awesome content and they also rank higher in youtube search, if you enhance your thumbnail I think more people will click and watch it.
You are evaluating two times total sales and the comparison method. You should hold that into variables inside each measure when you use them more than one time
Wow! this is awewome. Im beginning to love PBI now. Thanks Fernan, you're awesome too!
13:00 adding diff parameters to make card dynamic
This is gem of a content, just easy way to add colors at the last, since the data is in text format i used conditional formating for giving it a red or green, if it begins with '-' give me red font else green font. Its working well. Only thing is that the dash seperates the % with actual variance also change its color if you are fine with it you can follow this.
Oh man, this is exactly what I've been looking for. Thanks a lot. 😍😍
The parameter function can work as a slicer, I didn't know it before
Thank you for sharing; this video taught me many new things.
Same here. It solved a puzzle that i have been battling with for ages. Thanks @fernan
This is extremely helpful! I tried using the same method for multiple cards for different KPIs however I got a few different slicers. How can we sync the different slicers?
This is really good. Clear and simple, impressive.
This is so awesome! What if I was doing the sales of two departments and wanted "vs Last Month" to switch on both departments sales simultaneously with one click?
Extremely helpful, thank you!
I am new to PowerBI and found your video always very helpful, thank you! For color formatting, instead of creating this complicated measure and selecting that field when formatting, can we use rules (contains "+" then green, "-" then green)?
Yes you can! I just accomplished this in my dashboard using the following to create a new measure:
Color Indicator =
IF(
CONTAINSTRING([YourDAXMeasure], "+"),
"Green",
IF(
CONTAINSTRING([YourDAXMeasure], "-"),
"Red",
"DefaultColor"
)
)
@@danicatattoos thankyou so much
Hi Fernan, can you show also how you do the measure for every sales comparison folder as well?
Great video!! Can you please help me on how to use this setup for multiple KPI:s, but with one filter for "vs Budget" and "vs Last year".
Thank you for the video. How would I create a whole report of KPI cards on a report? for example imagine an excel sheet where cell has a conditional background and KPI values? is that possible?
Many thanks, where can I find the comparison table video?
What a clear explanation thanks man you provided a genuinely unbelievable content
Hatts off
Incredible helpful! I work in professional sport and am using this cars visual to score current vs best testing scores! I was wondering if anyone knew an easy way to create a measure that would allow me to see latest score put into a table based on the last completed screening of just the individual in a slicer! I've figured out a way to do this for last screening date inputed into the column but I'm finding issues when the last screening completed by a player isn't the same as the latest date inputed! Any help would be much appreciated 🙏🏼
Hi Fernan, great content: i use it in my KPI dashboards. I have a question: when you add more visuals like the one you showed (Total Sales) how can you combine all the comparison slicers into 1 slicer ie vs Budget, vs Last Year etc. I now get multiple parameter slicers for KPI_01, KPI_02, KPI_03. Hope you can help me out! Thanks in advance!
am wondering the same.
Did you ever figure this out? I am having the same issue
I have the same question
I have the same question
@@katiawei6817 You can achieve identical result using tabular editor and new card visuals. Write the code into tabular editor and create card visuals just to display values.
Que buen truco, no sabia que podia meter dos medidas en una tarjeta y como la utilizaste fue magico, gracias.
It is a fantastic video. Used it. Looking forward to more.
Just come across the video and it's exactly what I need for a dashboard reporting on net zero carbon emissions. Is there also a video explaining how to write the measures that you have here?
Hi...this is very helpfull...I try to produce several card as product comparison, however I found difficulties to show the Rank for selected product in the Card. Do you have any solution?
Wow, Amazing video!
Thank you
Outstanding! Thanks very much
Excellent tutorial. Awesome method of explanation.
Really useful. Great job, Fernan
Very well done!!! love it.
Amazing ! thank you !
Can we colorize only the percent and not both numbers ?
Also, how can I dynamize the number format (between millions, thousands etc)?
I am forward to a new job needs a presentation so thanks for your video
perfect. Thank you so much for these easy instructions
Is there a way to switch category too, i.e switching between total sales and products.
For the thousand separator, how would I be able to change it to a dot (.), instead of a comma (,)?
Thanks in advance!
Thanks for sharing Fernan, very helful
how would you do the red and green colours only for the % figure and not the figure next to the |
Thank you🎉, help me a lot
Excellent....
Excellent.
Amazing video! Thanks for sharing.
Fernand really awesome stuff! I've tried it myself and it works thanks to you mate!
Absolutely impressive !
Thank you for the helpful video!
in my case it gives an error can not compare text to intergers, can you help me in this please ?
Fantastic Fernan. Thanks 4 sharing
Very Helpful... Thank you so much
much needed one thanks sir!!!
Thanks Fenan, this is a Great video
You are awesome!!!! Great job.
How can a PowrBI report server version without a field parameter create function to make this sceario change?
Hi Everyone, I came across a way to overcome powerbi Report server version's shortage on dont have the field parameter function. I just created a new sceario table in the query and dont need to connect to them, then let it equal to a variable, and create another variable to calculate the sum up of the sales in different sceario. Then replace some the KPI _ACT vs BUD formula that the author has taught us, it is dynamic again!!!! Hope that will help if anyone have same problem as I do. Cheers!
KPI Color will not work for me. I get an error related to the comparison parameter. "Column Comparison is part of composite key, but not all columns of the composite key are included in the expression or its dependent expression". I've researched w/o luck. Any ideas? Thanks!
Very well done!
Great video. Thanks
Great content! thank you so much Ferdnand :)
Thanks Frenen it is very useful
Excellent
Thank you.
Grt ..... keep going on ...... Pls take different types of real time use cases
Awesome dude! Just used in in my dashboard. Thanks a lot!!!
Excellent!!!
It nice to look in the Dashboard bro... It was more helpful in saving space in the visual bro. But I need small help bro u had change the Color in the KPI here Possible to Change the color only the Percentage bro. if possible can make the video bro
Hi , sir thx a lot for the tutorial , I wish to design the card like you did on the video , but sadly , I have got only POWER BI Version: 2.112.1421.0 64-bit (January 2023) on my pc , so may I have your suggestion of how to do it ?
very handy and helpful
I am unable to see Title and Subtitle on under visual why? I have got the latest PBI model.
You have to enable in the option
Great! Thank you very much
I dont have this option in the latest upgrade.
Very helpful. Thank you!
Hi i have a doubt it might be a silly doubt,how to go to next line for defining variable??
shift+enter
It’s really great. Great job. Thanks a lot
Very nice.
Thanks.
Awesome fernan sir
Helpful, as usual! Thank you!
Excellent !
when using the FORMAT() function, I lose the ability to convert data type and only 'Text' is available. I noticed in this video you do not have the same problem. do you know why this is?
This is awesome!
thanks fernannn
Question?
How to show the total sales in K or M.
Example.
Your total sales 38516.
I wan show as 38 K.
Thank you
Go to call out value
Then display unit and select the thousands
Thank, very useful!
Well done!
Love the video, but I am getting a strange result. It works as described if the dataset is in the pbix, but if I try to do this with a thin report, the subtitle conditional format won't let me select the field. I have even tried copying across a working one and it breaks in the thin report. I suspect its a bug in the new visual.
did u add the step & " " to the measure?
This is necessary in order to format the measure as a text.
@@hendrik-stack22 yep. And this worked in the combined file - but not in the thin report.
Hey, I loved the new hair.
Great content
Great content. Thank you
Great job ❤
Very creative
Impressive!
Impressive
God bless you
😍 Love this nice card game
if i want the map color by district
really cool tks !
Great!
Nice...but if the number in Billions will that format work
Its not tkaing up the code after
| " & _sign & format(_var,"#0,#")
Great
Your videos have awesome content and they also rank higher in youtube search, if you enhance your thumbnail I think more people will click and watch it.
Not able to change color of kpi
Good
how will u format this the numbers are in millions or billions.. the example you showed is only having thousands.. can you show how to add K,M,bn
15:35 squeezing the card to its full potential
Great job. Good content. One request, please keep the mic away from the screen. Its a too much distraction and bothering the eyes a lot.
You are evaluating two times total sales and the comparison method. You should hold that into variables inside each measure when you use them more than one time
Please don't get me wrong I appreciate your intention to teach but have you realized that you tend to go back and forth between concepts a lot?