Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
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?
So the example was over simplified to show the principal what I want to do
I do understand that I can use other solution to compare data
But my question is: is it possible to connect slicer as in excel (Filter/Report Connections") as it can be useful in sometime
Yep, @PowerBIGuy is right.
Using Roleplaying dimensions is the best workaround here. Sorry I wasn't able to help more.
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |