Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.