cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

How can I define a parameter to have a label-value pair so that the user always sees the label?

Hi All,

Consider the scenario where I have a table of Countries

IDName
1United States of America
2France

 

  • I have a Query which is bound to a SQL stored procedure which accepts a Country ID and gives me some data specific to the Country. 
  • I have a simple Tabular report which is bound to the above SQL stored proc.

 

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @sau001 ,

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.

Advantages of Using a Filter

– 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.

 

Advantages of Using a Slicer

– 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.

View solution in original post

6 REPLIES 6
Highlighted
Solution Sage
Solution Sage

@sau001 

In Power Qeury Editor you can create a parameter based on Country Name. Did You Try?

Highlighted
Community Support
Community Support

Hi @sau001 ,

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.

Highlighted

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".

 
 

Slicer.PNG

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?

 

Slicer_benefit_page_filter.png

 

Thank you,

Sau

 

Highlighted

Hi @VijayP 

 

 
Thanks for looking into this.
This is how I know how to create a Parameter from the Power Query Editor.
 
 

Step 1 - Create a List query which returns the IDs

ListQuery.png

 

Step 2 - Create a new Parameeter which references this List for suggested values

 

Parameter.png

 

This works. However, what I want in the parameter is a label
IdLabel
2John Doe
3Jane Doe
which should resolve to the underlying Id. The raw Id makes little sense to the end user.
 
Is this possible?
 
 
Thank you,
Sau

 

 

 
Highlighted

@sau001 

Create a Custom Column to indicate what is John Doe and Jane Doe

and then create the parameter based on the Custom Column

Community Support
Community Support

Hi @sau001 ,

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.

Advantages of Using a Filter

– 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.

 

Advantages of Using a Slicer

– 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.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors