Forum Discussion
Compare / Analyse data - slicers to different objects
In excel it is possible to connect slicers to different objects
That function makes it possible to compare data for example two projects with each other
Possible workaround: I can duplicate the model
or duplicate slicer and with dax dis connect measures a to achieve the same result in Power BI
I do not think that is a good solution does anybody have a better solution
10 Replies
My workaround might not be the best but I provide two separate report filters to the same data and apply them to a dashboard to compare them side by side. Although, having the "Filter/Report Connections" ability that Excel has in Power BI would defnitely increase productivity.
see video https://youtu.be/aVr3uMLW1xk
The top slicer is connect t both pivot
The left bottom slicer is connect to the left pivot
The right bottom is connect to the right pivot
I'm not even sure what you are trying to do there from a business intelligence standpoint. It looks like you have projects A, M and X, and you are trying to compare costs based on a timeframe. (R1 and R2)
Why do you have two slicers that contain the same values (projects A,M,X)?
To compare the costs, just use the slicer on the timeframe, and graph the cost of both projects. If you aren't trying to do that... what are you trying to do?
Currently slicers are associated with all visualizations on a page via relationships. The Only workarounds are going to be manual. You can use role playing dimensions Project 1 and Project 2 dimensions but you would have to create custom measures using the userelationship function to activate and de-activate the appropriate dim/slicer. I don't know if it gets better than that.
Thank you all for the replies
- If you've not spotted it already, the recent updates add the ability to control 'Visual Interactions' which lets you decide which slicers are attached to which visuals. Hope that helps!
Can you give a little more examples, or data?
You can use report filtering, which will filter a report across multiple pages, but your data has to be set up properly and your model has to work with it.
Hi
Thank you for the reply
can I send you a small excel file as it is not possible to attached a file
Best Regards
Stefan
