Forum Discussion
Dynamic Cards by Selection on a Chart
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.
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 made
etc.
I've attached a screenshot to try and show what I mean.
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.