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

[Anonymous]

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

machineShift

[v-alq-msft]

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]

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]

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.

[Greg_Deckler]

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