Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I want to create slicer with value C1,C7,C28.When user select C28,then C1,C7 C28 should be filter and when user select C7 then C7 ,C1 should be filtered from below dataset.
PFB Below dataset for refernce
Date | Users | Metric |
2/5/2018 | A | C1 |
2/6/2018 | B | C1 |
2/7/2018 | C | C7 |
2/7/2018 | C | C28 |
2/8/2018 | D | C7 |
2/8/2018 | D | C28 |
Hi @atul9063,
I'm not so sure for your description, can you please explain more about your requirement? Such as some expected result.
Regards,
Xiaoxin Sheng
@v-shex-msftWhen User select C28,then all rows in below dataset less than equal to C28(i.e C28,C7 and C1 ) should be filtered and when user select C7 then all rows less and equal to C7(i.e C7 and C1) should be filtered.
Hi @atul9063,
Please refer to below steps to achieve your requirement.
Steps:
1. Create a new table with all metric types and use new table column as source of slicer.
Selector = VALUES(Table1[Metric])
2. Write a measure to compare selected metric and current row contents.
filter check = VAR selected = ALLSELECTED ( Selector[Metric] ) VAR _filter = MAXX ( SUMMARIZE ( FILTER ( ALLSELECTED ( Table1 ), [Metric] IN selected ), [Metric], "MinDate", MIN ( Table1[Date] ) ), [MinDate] ) RETURN IF ( SELECTEDVALUE ( Table1[Date] ) <= _filter, "Y", "N" )
Use raw data to create a table visual, drag above measure to visual level filter to filter 'N' result records.
Regards,
Xiaoxin Sheng
@v-shex-msft Actually below is dataset
Selecting churn7 on slicer would filter the below table for Churn='Churn7' or Churn='Churn1'
similarly on selecting churn28, filter would be Churn='Churn1' or Churn='Churn7' or Churn='Churn28' so output would be
TPIDChurn
1 | Churn1 |
2 | Churn7 |
3 | Churn1 |
4 | Churn28 |
5 | Churn7 |
6 | No Churn |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |