Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello Guys,
I have data like below screenshot
I have created a measure for filtering values with what-if parameter slicer (Percentage slicer)
When i apply the measure filter to the table it is showing wrong results as below
Here i have filtered only 1 values but it is showing 0's too. Percentage is also showing wrong and average measure value changed from 2536 to 4834 after applying the filter.
Attaching sample pbix for referrence
https://drive.google.com/file/d/1Z1uXXbRszEO--PT1GAiO6k4HsHhq-OM2/view?usp=sharing
Please help me on this!
Thanks in advance!
Hi @HemanthV
To begin with, the first page and the visuals are some how buggin, you should see it like this
Add a new Page and re create the visuals
Second what do you want to acheive with the parameter!! it is not clear
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @aj1973 ,
There is a grater% measure right, when i select 20 percentage in the whatif slicer. only 20% and above rows should appear in the table.
here attached i corrected your file
https://drive.google.com/file/d/12ZZiDrmi-NSeqZeXjmyaIJ4i0u6hRTxi/view?usp=sharing
Let me know
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @aj1973 ,
Thanks for the reply, but my requirement is that we need to show only rows above the entered percentage. In the above picture you attached you have entered 20% and 40% and 303% percent rows are correct but, the table needs to get filtered for only that 2 rows.
i have applied filter but getting result as below.
average measure is getting wrong value when applied the filter.
Please help me on this!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
69 | |
57 | |
37 | |
36 |
User | Count |
---|---|
83 | |
67 | |
62 | |
46 | |
45 |