Dynamic slicer

Used for anything related to the new Power BI Desktop and Service tools
Posts: 9
Joined: Sat Feb 01, 2020 8:51 pm

Dynamic slicer

Postby Eriha591 » Thu Sep 17, 2020 3:48 am


I am currently building for our store managers and I have a question regarding whether it is possible to have a dynamic slicer or not.

One tab in the report features two tables: one that shows how the store is performing in terms of sales on each department (which is one levels in our category tree) and one that shows the highest performing articles in the chosen (via a slicer) department on ALL stores. Just to give them some inspiration.

Now to my question: our category tree have many unique departments and I don't want our store managers to spend time on looking for the right department in the list. I would prefer that the slicer is dynamic and only shows low performing departments from the first table.

Is it possible to have a dynamic slicer?

Best regards

Return to “Power BI Desktop/Service”

Who is online

Users browsing this forum: No registered users and 2 guests