Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hello Guys,
I'm Creating my first paginated report and i got an issue in parameters i cant able to remove duplicates in parameters and i had imported data from power bi semantic model.Can anyone help me to solve it?
Solved! Go to Solution.
Hi,
regarding this, i did find a useful video to do with creating parameters for a pagnated report. Hope this helps.
How Parameters work with the Power BI Paginated Visual (youtube.com)
Thank you
Hi,
regarding this, i did find a useful video to do with creating parameters for a pagnated report. Hope this helps.
How Parameters work with the Power BI Paginated Visual (youtube.com)
Thank you
Parameters in a paginated reports are a bit different to a slicers in Power-BI. Duplicates are removed in slicers but in parameters you have to point to a source that already has distinct values. You should be able to do this in power query or point to a dimension table for the values.
| User | Count |
|---|---|
| 23 | |
| 20 | |
| 18 | |
| 16 | |
| 10 |
| User | Count |
|---|---|
| 53 | |
| 52 | |
| 40 | |
| 37 | |
| 32 |