Forum Discussion
Status Card Help
Anonymous
Try my solution in this post: https://community.powerbi.com/t5/Desktop/If-functions-on-cards/m-p/956277#M458252
Basically create a measure to replace the current measure that show "582nd" in card, something like:
new measure = IF(ISFILTERED(Table[Division]),[Current Measure],"Text")You can replace "Text" with the "overall avg" measure if needed.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Here is a screen shot. When I select one of the chart columns, it shows the data below and the card that shows 582nd right now changes to whichever column I select. When I unselect the column and all are shown, I am trying to get the 582nd to display "overall avg" or other text instead of 582nd, which isn't selected. It is defaulting to 582nd when nothing is selected. Hope this helps explain it.
Anonymous
Try my solution in this post: https://community.powerbi.com/t5/Desktop/If-functions-on-cards/m-p/956277#M458252
Basically create a measure to replace the current measure that show "582nd" in card, something like:
new measure = IF(ISFILTERED(Table[Division]),[Current Measure],"Text")You can replace "Text" with the "overall avg" measure if needed.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.