How to show multiple dynamic values in card based on the user selection.

[Chari]

Hi All................
I have below columns

Metric	Unit Range	Title
Value 1	0-35	Percentage of employees who have worked at least one week with more than' x' hours in after-hours unscheduled calls between <Date A> and <Date B>
Value 2	0-7	Percentage of employees who have at least one month where they averaged more than 'x' days active per week between <Date A> and <Date B>
Value 3	0-20	Percentage of employees who have at least one month where they averaged more than 'x' instant message hours between <Date A> and <Date B>

 
In PBI i have Metric slicer , Unit range slider, and a date between slider.

Requirement1: if I select a matrix value, the corresponding title should be appear in the card and whatever value selected in the Unit range slider  also should be updated in place of "X" in tile and whatever dates are selected in slider should be updated in title in the columns <Date A> and <Date B>.

Requirement1: How to store the Unit range. like For Value 1 range was 0 - 35  

[Anonymous · Accepted solution]

Hi @Chari ,

Use the following functions to accomplish your needs.

FIND function (DAX) - DAX | Microsoft Learn

REPLACE function (DAX) - DAX | Microsoft Learn

Final output

Best Regards,
Wenbin Zhou

[Chari]

Hi @Anonymous thanks for your response

facing one issue in Value1 we have range 35. 
if i select 35 in range filter and Value2 in Metric filter, the title getting error. Because we don't have the range 35 for value2.

Issue2:-
If i scroll start date, in message getting > after end date.