Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
machine
Shift
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.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
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.
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...
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
217 | |
89 | |
76 | |
66 | |
60 |