Dynamic Cards by Selection on a Chart

[Jonny1541]

Hello @all 

I am trying to get the values of a Card visual to update based on the selection made in a Funnel Chart. The catch is I have 9  levels of drill down in the chart, and I want each card to react to a specific level of drill down. I have managed to get a 'Heading' card to update using the below DAX, but when trying to repeat for values, they are dynamically altered by all subsequent selections as well. Is it possible to just get the values to update once on the relevent selection?

DAX for updating 'heading'

Selected Meter Text =

VAR SelectedMeter = SELECTEDVALUE('RG Removals'[Meter Type], "All Meters"

)

RETURN

    SelectedMeter

[v-dineshya]

Hi @Jonny1541 ,

Thank you for reaching out to the Microsoft Community Forum.

For every selection in the funnel/drill hierarchy continues filtering the entire visual context, so all cards keep reacting to deeper selections. To get the desire result, each card should respond only to its own hierarchy level and deeper drill selections should be ignored for earlier cards.

Please try below steps.

1. Create Separate Measures Per Level.

Card 1 (Meter Type): This card should ONLY react to Meter Type.

Card 1 Meter Type =
CALCULATE(
SELECTEDVALUE(
'RG Removals'[Meter Type],
"All Meters"
),
REMOVEFILTERS(
'RG Removals'[Primary or Churn],
'RG Removals'[Comms Status],
'RG Removals'[IN_CONTRACT_FLAG],
'RG Removals'[IN_TERM_FLAG],
'RG Removals'[PROTECTED_FLAG],
'RG Removals'[Peppercorn_At_Removal],
'RG Removals'[CalisenAssetInstalled],
'RG Removals'[Outcome Category]
)
)

2. Card 2 should react to Meter Type and Primary or Churn. But ignore everything below.

Card 2 Primary or Churn =
CALCULATE(
SELECTEDVALUE(
'RG Removals'[Primary or Churn],
"All"
),

REMOVEFILTERS(
'RG Removals'[Comms Status],
'RG Removals'[IN_CONTRACT_FLAG],
'RG Removals'[IN_TERM_FLAG],
'RG Removals'[PROTECTED_FLAG],
'RG Removals'[Peppercorn_At_Removal],
'RG Removals'[CalisenAssetInstalled],
'RG Removals'[Outcome Category]
)
)

3. Each next card removes only lower-level filters.

Card 3 Comms Status =
CALCULATE(
SELECTEDVALUE(
'RG Removals'[Comms Status],
"All"
),

REMOVEFILTERS(
'RG Removals'[IN_CONTRACT_FLAG],
'RG Removals'[IN_TERM_FLAG],
'RG Removals'[PROTECTED_FLAG],
'RG Removals'[Peppercorn_At_Removal],
'RG Removals'[CalisenAssetInstalled],
'RG Removals'[Outcome Category]
)
)

Note: Please use above measures to get the desire result.

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

[v-dineshya]

Hi @Jonny1541 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[v-dineshya]

Hi @Jonny1541 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[MFelix]

Hi @Jonny1541 ,

Not sure how you have the funnel setup but for this you need to calculate your measure based on the drill-down you are at, so the question is the way you have the drill down and how it should impact the measure calculation.

What is the intended calculation you need for each level do you want to keep all cards with the same value or at the top level of that specific selection.

Example:

Level 1 - Market

Level 2 - Product

When I select product the Market card gives me all the totals for the total value of that market or do you want to have the total value has if there was no selection at market level.

[Jonny1541]

Thanks @MFelix ,

I currently have the funnel chart set up with just a total volume in the values, and then the various categories going down through the drill down. But I then want to have a series of cards across the top that only display each relative level of the drill down.

e.g. Card 1 will show Level 1 when a selection has been made, but not when a Level 2 selection has been made.
Card 2 will show Level 2 when a selection has been made, but not alter when a level 3 selection has been made

etc.

I've attached a screenshot to try and show what I mean.

[MFelix]

Hi @Jonny1541 ,

So based on your model this means that you will always get 233 K at all the cards except the one that is filtered is that correct.

So if you are at contract status and select a value then that card will be filtered and all others will get the 233K.

[Jonny1541]

@MFelix , all the boxes are filtering for every level of drill down