Show blank card when field in decomposition tree not selected

[user180618]

I've got a decomposition tree and two cards on a page (a regular card and a multi-row one). Currently when one of the fields in the decomposition tree is selected, the regular card shows the 'First' field and the multi-row card is set to Don't summarize so that it shows all of the related fields.

What I would like is for the cards to show no values if no fields are selected in the decomposition tree. Is there a quick measure that can do this?

[Anonymous · Accepted solution]

Hi @user180618 ,

Please try:

Measure 2 = IF(ISFILTERED('Table'[Column2]), CONCATENATEX(ALLSELECTED('Table'),[Card1],","),  "(Not Selected)") 

// CONCATENATEX(FILTER('Table',[Column2] in ALLSELECTED('Table'[Column2])),[Card1],",")

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @user180618 ,

If possible, could you please share me with your pbix file after removing sensitive data?

Refer to:

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

[user180618]

Thanks @Anonymous, here is the pbix file: https://we.tl/t-lAnbDyIfda

[Anonymous]

Hi @user180618 ,

Please use ISFILTERED():

For Card = IF(ISFILTERED('Item'[Category]),CONCATENATEX(ALLSELECTED('Item'[Category]),[Category],",") ,"(Not selected)")

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[user180618]

Thanks Eyelyn. This has partly worked, but I would like the card to show a different column when filtered (not the same Category one like in your image).

The measure works exactly how I want it to when unfiltered:

But when filtering it shows the Column2 selection:

Whereas I want it to show the Card1 column when filtered, as below:

How can I slightly change your formula to show that?

When I changed it to the below, it just gave me all of the Card1 values:

[user180618]

To illustrate this with an example.

When a field is selected the cards are fine as they are:

But how can I make the cards show blank values when nothing is selected in the decomposition tree: