Dynamic Bench marking in Line and Stacked Column Chart

[singhal14]

Hello Everyone,

I am trying a Scenario where I need to add many Slicer Visuals to compare other visulas accordingly.

Problem is I need to follow a filter Hierarchy, something like  "a->b->c->d->e".  I am not allowed to select random filter but user can do it any way so one question would be-

How to tell Power BI this Hierarchy solution using Dax ?

The second thing is I need the answer till second last filter like if user selects "a->b->e" / "b->a->e" then the answer will be shown till the "a->b".

Hope you get the problem, this could be a tricky thing in Power BI to do.

If you need any clarification on this problem, please let me know.

Since I know DAX is a very powerful in purpose to solve this type of Scenario but I am new to Power BI and don't know lots of DAX functions, so any help would be useful.

Thanks,

Akash 

[v-ljerr-msft]

Hi @singhal14,

In this scenario, I would suggest you to use the HierarchySlicer custom visual instead of using Dax. With the hierarchy slicer it is possible to represent a hierarchy as a single slicer. The different levels are shown as a tree.

Regards

[singhal14]

Hi @v-ljerr-msft,

Thanks for reaching out.

We thought about this approach before but the problem is in our data, the no. of unique values are very high. So it is not very likely to use Hierarchy Slicer here.

Also this approach does not solve the second part of the problem mentioned in the Question.

If you have any other approach, please let us know.

Thanks,

Akash