Presenting different data in two columns of a table using two identical slicers

[Anonymous]

Dear experts,
I am quite new to POWER BI so I hope you can help me. I have a simple table which looks like this.

The purpose of this table is to compare different expenses or revenues with eachother in the columns during the course of a year. I have two identical slicers with for example values A until F. What I want to accomplish is if I click ‘A’ in slicer one and ‘C’ in slicer two, that the two columns display different data in order to compare them. But because the input data for the table and the slicers is the same, I now get an empty table. Can anyone help me? Thank you in advance!

Please note that it is desired to compare any given pair of slicer indices, so A&C, B&C, E&F etc. but also C&A, C&B, F&E

[v-tangjie-msft · Accepted solution]

Hi @Anonymous ,

The current system does not support this function. You can post your idea to Ideas .

https://ideas.powerbi.com/ideas/

You can create two visuals, the first visual places only column 1 and the second visual places only column 2, then create two slicers with the same field, set slicer 1 to interact with visual 1 and slicer 2 to interact with visual 2, select one visual, hold down [ctrl] to select the remaining three visuals, right-click [Group].

Then the result is as follows.

Please refer to the following document for more information.

Change how visuals interact in a report - Power BI | Microsoft Learn

Solved: Use two identical slicers for same visual - Microsoft Power BI Community

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Anonymous]

Deer Neeko,

Thank you for your help! This will help me.

Kind regards,

Tom