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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Text boxes and card values above the bar chart should reflect dynamically according to the x-axis

Hi,

 

I am trying to create the same report in power bi as it exists in tableau. Tableau uses parameters to choose between the x-axis(dynamic selection) since power bi query parameters are applicable only in desktop, i used the combination of selection pane, buttons and bookmarks to achieve the dynamic x-axis selection, however the text and card values above the bar chart are hardcoded and chosen individually, but when  the x-axis changes to different selection, I need to add different text and card values. is there any way to achieve this dynamically? meaning if the user selects machine, the text and card above the bar chart of machine should show machine values like u01,u02 etc and whne the user selects the shift, the text and card above the bar chart should show shift values like 'F' and 'B'

 

below is the tableau visual that i need to achieve the same in power bi

 

 

machinemachineShiftShift

 

4 REPLIES 4
v-alq-msft
Community Support
Community Support

Hi, @Anonymous 

 

I'd like to suggest you create a new parameter table with categories and the corresponding values. Then you may use query parameters to paramterize the table. You may also refer the following link.

Dynamic change in X Axis 

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Hi,

 

Does query level parameters work in power bi service? As per my understanding, query level parameters works only in desktop and not in Service. Please confirm.

 

I could have used query level parameters to achiev the dynamic x-axis selection but i didn't use it because i need the users to select the parameters from Power bi service.

hansei
Helper V
Helper V

If you are using bookmarks, use them to achieve your result. When bookmark A is clicked, hide the text boxes and card values that do not apply. When bookmark B is clicked, toggle visibility.

 

You can toggle visibility by enabling the Selection Pane and then updating your bookmarks.

 

selpane.png

Greg_Deckler
Super User
Super User

Really very little information to go on here. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

In general however I use Card visualizations coupled with measures to display dynamic text based on user selections. For an example of what you can achieve with this, https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer...



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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