Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Team,
User want to filter Revenue data using screen level slicer. Don't want to apply filter on filter pane.
I have a Revenue measure .it contains overall revenue amount. Here user need a slicer to check >100Million or <100Million Revenue Brands. So i want to add a slicer it contains >100M,<100M .when user click on on the slicer ,slicer drop down should visible >100M,<100M only. user flexbele to choose from drop down and filter the data. Currently my [Revenue] measure is sum of amount.
How i can achive this . can anyone help me.
Solved! Go to Solution.
Hi @VikramAdi ,
You can follow these steps below:
1.Add new table.
2.Add FLAG measure and put it into fliter.
FLAG =
VAR _judgement =
IF ( [Revenue] > 400, ">400", "<400" )
RETURN
IF ( _judgement IN ALLSELECTED ( 'Table 2'[SELECTED] ), 1, 0 )
Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @VikramAdi ,
Depending on the information you have provided, you can follow these steps below:
1.Add a new table as a slicer.
2.Add new measures.
REVENUE<400 =
IF ( SELECTEDVALUE ( 'Table 2'[SELECTED] ) = "<400" && [Revenue] < 400, 1, 0 )
REVENUE>400 =
IF ( SELECTEDVALUE ( 'Table 2'[SELECTED] ) = ">400" && [Revenue] > 400, 1, 0 )
FLAG =
IF (
SELECTEDVALUE ( 'Table 2'[SELECTED] ) = "<400",
[REVENUE<400],
[REVENUE>400]
)
3.Put FLAG in Filters.
Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your response @v-yifanw-msft . Your approch working fine. When i choose multi select in slicer result coming empty.Single select working fine. can you please suggest for multi seletion(>400 and <400)
Hi @VikramAdi ,
You can follow these steps below:
1.Add new table.
2.Add FLAG measure and put it into fliter.
FLAG =
VAR _judgement =
IF ( [Revenue] > 400, ">400", "<400" )
RETURN
IF ( _judgement IN ALLSELECTED ( 'Table 2'[SELECTED] ), 1, 0 )
Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
87 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |