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.
I have a Fact table in SSAS Tabular model which contains column name "Flag" with only possible values Yes or No,
I have to create a slicer Control with Yes or No, If user clicks Yes then it should filter Only Yes records but if User Clicks in No It should display all records without applying any Filter. So can you help me how to achieve this.
Solved! Go to Solution.
@Anonymous,
Add a separate table for Slicer, drag measure below to Visual level filters and set Show items when the value is 1.
Table = DISTINCT ( 'Fact'[Flag] )
Measure = IF ( SELECTEDVALUE ( 'Table'[Flag] ) = "Yes" && SELECTEDVALUE ( 'Fact'[Flag] ) = "No", 0, 1 )
@Anonymous,
Add a separate table for Slicer, drag measure below to Visual level filters and set Show items when the value is 1.
Table = DISTINCT ( 'Fact'[Flag] )
Measure = IF ( SELECTEDVALUE ( 'Table'[Flag] ) = "Yes" && SELECTEDVALUE ( 'Fact'[Flag] ) = "No", 0, 1 )
Hello @v-chuncz-msft , Can you please help me with sample PBIX file, the below expression not working.
I have delete the relation between them and it automaticall working thank you for the solution.
It is not working, Can you please share sample PBIX file.
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |