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 Team,
Looking for an output like below. In this table dimension and measures both are dynamic and i want to be able to select and display multiple dimension and multiple measures. After trying for a week, i am here for help from experts. @amitchandak sir
Raw data looks like this
Year | Period | PartnerType | Process | Line | Spoc | Tre | GST_HO | ServiceLine | SSC | Final NPS | CES | Overall Satisfaction | Verbatim |
2022 | 2022Q1 | Operational | All | M | Chris | 1 | GST | SCM | NA | 10 | 5 | 5 | |
2022 | 2022Q1 | Other | Commercial | G | Dora | 1 | GST | Business | NA | 10 | 5 | 5 | abcd |
2022 | 2022Q1 | Operational | All | S | Robert | 2 | GST | Global | NA | 10 | 4 | 5 | point teryuoio |
2022 | 2022Q1 | Operational | Commercial | H | John | 2 | HO | Business | NA | 10 | 5 | 5 | up sell |
2022 | 2022Q1 | Operational | IS | M | Abhi | NA | HO | S&O | EZU | 8 | 3 | 4 |
|
@Seer_Bug , For measure slicer we can use measure slicer (dax of calculation group)
measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://www.youtube.com/watch?v=vlnx7QUVYME
Axis Slicer
Three approch from Guyinacube https://www.youtube.com/watch?v=dYmzb5UMkXw
Dynamically change chart axis in Power BI
bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/
For measure slicer - i tried most videos on youtube , however those only allow me to select one measure at a time. in your video for example , i can only display MTD or YTD. What i am looking for is - to display MTD and YTD or 2 or 3 things together.
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |