Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Help needed with using multiple slicers for parameters and filters in visualisations

Hi all. In Power BI I’m trying to replicate a report that was created by a former colleague in Tableau, however I’m encountering issues with using multiple interacting parameters and other slicers in...
  • MFelix's avatar
    MFelix
    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.