Is it possible to conditional fill de color of a shape depending on the value of a measure? I'd like to have a green fill of a square when the measure is not blank and a red fill when it is blank. Despite my own efforts and internet search I'm still not capable. So I can use some help 😉
Thanks in advance!
PZU
Solved! Go to Solution.
@PZU_DGW
IF you are using different measures, then you need to apply them individually.
There is a way to automate by using Calculation Group in Tabular Editor
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@PZU_DGW
Make sure you have the latest Power BI desktop version installed. Create a measure like the one below.
CF Measure = IF( ISBLANK([Yourmeasure]) , "Red" , "Green" )
Under Fill, choose the fx and apply the measure under filed value.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Dear Fowmy,
Thanks for your reply and it works..but there's a catch. Unfortunatly is do have 9 buttons in my report (please dont't ask me why). Is there a way I do not have to make 9 separate measures to check the value? I already guest that I will make 2 color-measures (for with and without value) so i can change the colorstyle easily.
Thanks so far!
@PZU_DGW
IF you are using different measures, then you need to apply them individually.
There is a way to automate by using Calculation Group in Tabular Editor
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
I've read about Calculation Groups, but for now I will make 9 separate measures. Thanks for the help (again!). I will take the time to figure out calculation groups later.
Greetings,
PZU
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
107 | |
74 | |
66 | |
50 | |
49 |
User | Count |
---|---|
163 | |
85 | |
76 | |
68 | |
67 |