Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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
User | Count |
---|---|
101 | |
69 | |
58 | |
47 | |
47 |