Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
Consider the scenario where I have a table of Countries
ID | Name |
1 | United States of America |
2 | France |
Question
How can I make my parameter selection more intuitive for the end user by displaying a drop of Country names (United, France, etc.) as opposed to Country IDs (1,2, etc.) . This was very easy in SSRS.
Thanks,
Sau
Solved! Go to Solution.
Hi @Anonymous ,
Both slicers and filters refine query results, but the main difference is that a slicer operates on-canvas, whereas, filters are configured and operate in the background of reports. The main difference between a Power BI slicer and a filter is that a slicer is an on-canvas, dynamic feature, whereas, a filter (page level in this case) is a hidden, static feature. Furthermore, a filter can refine an entire report, just a page or simply a visual on the canvas.
– It can be applied on different levels: Report, Page and Visual.
– A filter can be applied to a specific object on the page, such as tables, charts or cards.
– It can be applied between pages of the same report.
– A filter can be used to reference objects across other reports.
– A slicer is user friendly; they are displayed on the canvas.
– Report users can pick and choose what they want displayed in the visuals.
– Even though slicers are restricted to a report page, you can add slicers to several pages and synchronize their actions across those same pages.
You can refer this blog: The Differences Between a Power BI Slicer and a Filter
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Besides create parameters in power query editor, you can also try to use the country field to create a slicer in the report directly to filter specific country data in power bi desktop.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @VijayP
Step 1 - Create a List query which returns the IDs
Step 2 - Create a new Parameeter which references this List for suggested values
Id | Label |
2 | John Doe |
3 | Jane Doe |
@Anonymous
Create a Custom Column to indicate what is John Doe and Jane Doe
and then create the parameter based on the Custom Column
Proud to be a Super User!
Hi @v-yingjl
Yes, slicers does appear to solve my problem. In the example below, I have bound a slicer using a computed column "FullName".
Question
What benefit does a Slicer visual have over simple Filters . I could have achieved the above by dropping the FullName column into the "Filters on this page" panel?
Thank you,
Sau
Hi @Anonymous ,
Both slicers and filters refine query results, but the main difference is that a slicer operates on-canvas, whereas, filters are configured and operate in the background of reports. The main difference between a Power BI slicer and a filter is that a slicer is an on-canvas, dynamic feature, whereas, a filter (page level in this case) is a hidden, static feature. Furthermore, a filter can refine an entire report, just a page or simply a visual on the canvas.
– It can be applied on different levels: Report, Page and Visual.
– A filter can be applied to a specific object on the page, such as tables, charts or cards.
– It can be applied between pages of the same report.
– A filter can be used to reference objects across other reports.
– A slicer is user friendly; they are displayed on the canvas.
– Report users can pick and choose what they want displayed in the visuals.
– Even though slicers are restricted to a report page, you can add slicers to several pages and synchronize their actions across those same pages.
You can refer this blog: The Differences Between a Power BI Slicer and a Filter
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
In Power Qeury Editor you can create a parameter based on Country Name. Did You Try?
Proud to be a Super User!
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |