Trying to get a card to 'Don't Summarise' or to show the value for the selected company

[JordanJackson]

Hi there,

I am experiancing an issue when trying to get the card selected in the attached photo to show whether a company is restictred/suspended or cleared. Seen on the drop down in the feilds section there is no option for no summarisation which means that only the first, last or count can be shown. None of these display the text in the column that I want, I can only get it to display the numbers that I use for the conditional formatting. 

Essentially , I am looking for this card to display the status of the company. Enabling dont summerise or having another way to show the text would be great.

Thankyou

[v-jingzhang · Accepted solution]

Hi @JordanJackson 

A Card visual is designed to show only one value. So when you put a column field into it, it should apply an aggregation on that column to get the aggregated result. If this column only has one distinct value when you apply some filters on the report, selecting First or Last will give you the same result as the distinct value. You can select First to check the result. 

Don't summarize option is ony available in Table visual and Multi-row Card visual. For other visuals, they all expect to have aggregated values. If you have multiple values to show, you can try the Multi-row Card visual which is next to the Card visual. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[serpiva64]

Hi, 

You can try with this measure

Measure = SELECTEDVALUE(fieldname,BLANK())

in this exemple

Measure = SELECTEDVALUE(dimStore[Status],BLANK())

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !