Forum Discussion
Help needed with using multiple slicers for parameters and filters in visualisations
- 2 years ago
Hi Anonymous ,
When you select Open/ReOpen from the status, you refer that the chart should not be affected by any date filter, what does this mean exactly, you get all the data from the table?
For this you need to update your measures to something similar to this:
Sum of Count = SWITCH( TRUE(), SELECTEDVALUE(Claims[Claim Status]) IN { "Open", "Re-Opened" }, SUM('Claims'[Count]), IF( SELECTEDVALUE('Date to Use'[Date to Use]) = "Accident Date", CALCULATE( SUM('Claims'[Count]), USERELATIONSHIP( Claims[Accident Date], 'DATE'[FULL_DATE] ), 'DATE'[FULL_DATE] in values('Date Range'[FULL_DATE]) ), CALCULATE( SUM('Claims'[Count]), USERELATIONSHIP( Claims[Registration Date], 'DATE'[FULL_DATE] ), 'DATE'[FULL_DATE] in values('Date Range'[FULL_DATE]) ) ) )This measure also solves the question about the date range.
Concerning the split of the measure by Colour BreakDown and Metric, not really sure what you mean?
You want to present both measures claims and total payments in the same bar chart with the split of the Color breakdown? Can you give more specifications on this?I apologize for the questions but is a complex request so trying to do it a question at a time.
Hi Anonymous ,
When you select Open/ReOpen from the status, you refer that the chart should not be affected by any date filter, what does this mean exactly, you get all the data from the table?
For this you need to update your measures to something similar to this:
Sum of Count = SWITCH(
TRUE(),
SELECTEDVALUE(Claims[Claim Status]) IN {
"Open",
"Re-Opened"
}, SUM('Claims'[Count]),
IF(
SELECTEDVALUE('Date to Use'[Date to Use]) = "Accident Date",
CALCULATE(
SUM('Claims'[Count]),
USERELATIONSHIP(
Claims[Accident Date],
'DATE'[FULL_DATE]
),
'DATE'[FULL_DATE] in values('Date Range'[FULL_DATE])
),
CALCULATE(
SUM('Claims'[Count]),
USERELATIONSHIP(
Claims[Registration Date],
'DATE'[FULL_DATE]
),
'DATE'[FULL_DATE] in values('Date Range'[FULL_DATE])
)
)
)
This measure also solves the question about the date range.
Concerning the split of the measure by Colour BreakDown and Metric, not really sure what you mean?
You want to present both measures claims and total payments in the same bar chart with the split of the Color breakdown? Can you give more specifications on this?
I apologize for the questions but is a complex request so trying to do it a question at a time.
Thanks MFelix - this definitely put me on the right path. The two SWITCH statements I ended up using were:
and