Forum Discussion
Dynamic Cards by Selection on a Chart
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'
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
Thanks Dinesh, this has solved the problem.
8 Replies
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
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
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
Thanks Dinesh, this has solved the problem.
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.
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 madeetc.
I've attached a screenshot to try and show what I mean.
