Status Card Help

[Anonymous]

I created a line and stacked column chart and am using different cards to visualize different numbers when I select the particular item from the chart.  So far, it's working as I designed it.  When I unselect an item in the chart, one card defaults to the 1st line of my data (shows project name), the other card shows the overall average, which is what I want.

How do I get the first card that shows project name to show company name vice 1st line of data (1st project name in dataset)?

Thanks

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Anonymous]

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 · Accepted solution]

@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.