The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi all,
Due to the normal cards being unable to left allign, and the 'card with states' being slow and unable to 'bold' text I am currently using 'advance card' visualisation on my dashboard.
I have (Blank) values pop up as i am using the same measures on a table. If I don't use the (Blank) as a result in the formula, the matrix table includes the entire date table.
I want the (Blank) values font to appear as white so it looks blank in the dashboard when there's no data.
Is there a way to do this?
Why are the cards functions so bad 😕
Solved! Go to Solution.
@NMil , usually conditional formatting does not work with blank. But if field values conditional formatting is supported in that visual, You can use this measure in conditional formatting using field value
You can use
measure = if(isblank([measure]), "white", "black")
Hi @NMil
Could you share some pictures of that visual and the dax expression in it? So that I can see if it can achieve this effect by changing part of the code.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
@NMil , usually conditional formatting does not work with blank. But if field values conditional formatting is supported in that visual, You can use this measure in conditional formatting using field value
You can use
measure = if(isblank([measure]), "white", "black")
User | Count |
---|---|
65 | |
60 | |
60 | |
53 | |
27 |
User | Count |
---|---|
181 | |
88 | |
70 | |
48 | |
46 |