Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I would like to include the ability for users to select which measure they want a line graph to show.
ie: I have a line graph with 3 measures (Sales Cost, Product Cost, Order Cost) and lets say the user just wants to see the order cost and product cost over a period of 6 months, they would select those 2 measures from a slicer and 2 lines on the graph should appear.
I have seen this been done in DAX using a combination of a measure table and dax functions (the BI Elite Youtube Channel has a good walkthrough: https://www.youtube.com/watch?v=OIGGrrnMIgk), however my report is connecting to a multi-dimensional SSAS cube via LiveConnection therefore I dont have the ability to input DAX here.
Has anyone been able to replicate the measure slicer logic explained above for a Power BI report hooked up to a multi-dimensional cube?
Thanks,
Nuemio
Hi
Were you able to get a solution for this? Facing the same issue.
You can do that with dynamic measure swaps but you cannot change the number of displayed measures. Ie you cannot have two lines for one set of measures and three lines for another set of measures. (assuming each measure is its own line, not talking about legends here)
Thank you! I will try this
How do I do dynamic measure swaps when my data source is a cube? I searched for dynamic measure swaps and it seems I need to create that will contain values to show in the slicer but my data connection will not allow me to create a table such as this.
User | Count |
---|---|
13 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
24 | |
3 | |
3 | |
2 | |
2 |