Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I need to use a card visual (or similar) with in my Tachometer gauge. when data is N/A Tacho gauge disapears automatically but the cards I placed inside them just show Blank. now, my question is:
How I can get rid of card visuals inatead of showing Blank? The current issue with them is that even when I remove the data lables when Blank, I can not remove the Titles of my Card. What is the DAX formula for it?
P.s. I also used Advanced Card visual but still impossible to remove titles.
Many thanks dear supporters
Solved! Go to Solution.
Hey,
I'm referring to the title of this thread.
You can use a measure (you have to use the latest version of Power BI - June 2019 releaese), that returns an empty string when anoter measure is blank. Create a measure like so:
vizAid Card Title (no title when measure is blank) = var theValue = [Total Quantity] return IF(ISBLANK(theValue) , "" , "The amount is " & theValue)
Then you can assign this measure to return the text, this text will be used as title:
Please be aware, that you have to come to close to the region of upper arrow to make "3 little dots" appear, using these dots, you can enter the conditional formatting.
From this dialog you can select the measure from the table it is assigned to:
Hopefully this is what you are looking for.
Regards,
Tom
Hey @Anonymous ,
at the current moment Power BI does not support to "show / hide" a visual based on a measure value.
For this reason, you can try to set the fill color and data label to the same color as the background. Please be aware, that then you will have a blind spot on your report page.
Hopefully this provides some additional ideas.
Regards,
Tom
Thanks @TomMartens ,
I don't get it, my question was about how to hide the title of the tachometer visual when the data is N/A. I don't concern the data label. Please advise a good solution.
Thanks again
Hey,
I'm referring to the title of this thread.
You can use a measure (you have to use the latest version of Power BI - June 2019 releaese), that returns an empty string when anoter measure is blank. Create a measure like so:
vizAid Card Title (no title when measure is blank) = var theValue = [Total Quantity] return IF(ISBLANK(theValue) , "" , "The amount is " & theValue)
Then you can assign this measure to return the text, this text will be used as title:
Please be aware, that you have to come to close to the region of upper arrow to make "3 little dots" appear, using these dots, you can enter the conditional formatting.
From this dialog you can select the measure from the table it is assigned to:
Hopefully this is what you are looking for.
Regards,
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |