Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
Solved! Go to Solution.
@Paulyeo11 , Based on what I got.
One option - Bookmark and buttons. - https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
refer to these two
Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/
@Paulyeo11 , if you slicer from the table or table joined to it you do need to use selected value. Also what do you mean by not dynamic ?
use in 'SALES'[GROUP_CLASS] in values( 'SALES'[GROUP_CLASS]) for all values. Selectedvalue will give only one value.
Hi Amit
Thank you for your fast reply.
Dynamic = Only using one Table and user can select to view report Brand or SBU by click the Slicer.
Paul
@Paulyeo11 , Not clear. Can you explain
Hi Amit
Below link is my PBI file :-
https://www.dropbox.com/s/78masspm617220k/PBT_SAMPLE%20100%20ROW%20JAN%202021%20V005.pbix?dl=0
Now i need to have 2 Table , i want to reduce to 1 Table .
I am thinking using Slicer , since BRNAD_C and GROUP_CLASS they are fields , i cannot put in Slicer. not sure how to use personlise mode , allow user change field.
@Paulyeo11 , Based on what I got.
One option - Bookmark and buttons. - https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
refer to these two
Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |