Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello.
Is there a way to show/hide a visual (a card, table, matrix) when the report is launched, based on the value of a measure. This does not depend on user interaction, such as using a slicer (my report won't have any).
In the sample report attached, if the measure's value = 1 I want the card to be hidden, else displayed. The "Show items when the value" option is disabled.
Thanks.
Solved! Go to Solution.
power bi doesnt support this as far as i know .
added to this, you can't add a measure to the filter pane for kpi visuals.
what you can do, is in the dax code
check if your measure returns certain value , then blank() , else , [ your calculation]
drag and drop this measure to the visual.
although this wont hide the visual, but the visual will show no data when your condition is met .
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠
power bi doesnt support this as far as i know .
added to this, you can't add a measure to the filter pane for kpi visuals.
what you can do, is in the dax code
check if your measure returns certain value , then blank() , else , [ your calculation]
drag and drop this measure to the visual.
although this wont hide the visual, but the visual will show no data when your condition is met .
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠
User | Count |
---|---|
81 | |
75 | |
73 | |
42 | |
36 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |