Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
Anonymous
Not applicable

Tableau parameter in PowerBI

Hi,

 

I would like to give my users ability to see the report from different perspectives. A drop down with the dimentions should let them swap.  For e.g. below will be the values in the parameter.

 

Region
Country
State
Customer

In tableau i would create a string parameter and use this parameter in the calculated field and then that calculated field will be used in the visuals , so when i change the value in the Parameter Dropdown the Dimention on the visual changes.. Below is the example  of joining using the parameter...

CASE Parameter

When "Region" Then Region(Dimention)

When "State" Then State(Dimention)

When "Country" Then Country (Dimention)

When "Customer" Then  Customer(Dimention)
END

6 REPLIES 6
seaotter
New Member

Please follow this thread regarding Tableau like parameter function: https://community.powerbi.com/t5/Desktop/How-to-create-Parameter-Like-in-Tableau-to-select-visualizi...
seaotter
New Member

Please follow this thread regarding Tableau like parameter function: https://community.powerbi.com/t5/Desktop/How-to-create-Parameter-Like-in-Tableau-to-select-visualizi...
zebing2
Advocate II
Advocate II

Why on earth is this thread marked as "solved". When someone comes along and says there is no solution, we're marking it solved on this forum?

v-sihou-msft
Microsoft Employee
Microsoft Employee

@Anonymous

 

In Power BI, you can only select one perspective after connecting to cube/model, it's not possible to dynamically switch perspectives. And it's not supported to use parameter to dynamically select dimensions. 

 

Regards,

Anonymous
Not applicable

Is there any workaround for it ? May be Bookmarks ?

In power BI it's not possible to select dynamically like tableau parameter.

 

In power bi You have to bookmarks for every category.

 

Regards,

Bajee.

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.