topic Re: Dynamically Add or Remove Measures from Visual - multidimensional cube in Developer

Dynamically Add or Remove Measures from Visual - multidimensional cube

Nuemio — Wed, 25 Sep 2019 15:27:43 GMT

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

Re: Dynamically Add or Remove Measures from Visual - multidimensional cube

Lethabo5 — Wed, 10 Jun 2020 08:14:45 GMT

Were you able to get a solution for this? Facing the same issue.

Re: Dynamically Add or Remove Measures from Visual - multidimensional cube

lbendlin — Wed, 10 Jun 2020 13:11:46 GMT

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)

Re: Dynamically Add or Remove Measures from Visual - multidimensional cube

Lethabo5 — Wed, 10 Jun 2020 17:59:17 GMT

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.