Forum Discussion

deb_power123's avatar
deb_power123
Helper V
5 years ago

How to filter duplicate columns with same filter values separately in matrix visualization -PowerBI

Hi Experts,

 

I have a table named sales with three columns: 1)QuaterYear 2)Place 3)SalesAmount-scenarioA.

 

I have duplicated the column 'SalesAmount-scenarioA' and named it 'SalesAmount-scenarioB in modelling view of PowerBI.I have added 2 filters for values QuaterYear with name QuaterYearscenarioA and QuaterYearscenarioB in my visualization .

 

I want my filters to filter these two duplicate columns seperately in the table visualization as if they are two different columns and they arent related to each other.For example: if I filter the first column 'SalesAmount-scenarioA' then the values of SalesAmount-scenarioB'should not change.Rightnow if I select any value in first filter the second filter gets preselected and both the column values gets changed. Though I understand why it happens but my reuirement is to filter both these columns independently. In other words like implementing filter columns in table visualization, since powerBI doesnt have one so I am trying to workaround.

 

This will help me to compare the values through filter for different Quateryear for different scenarios.

 

How can I handle this case , is there any DAX Calculations or measures you could provide me which I can try? Please help. I have added my input data values for reference .

 

My modelling tab: where I duplicated the columns

My visualization:

 

Input data source-Excel

QuaterYearSalesAmountPlace
Q120171000London
Q120171100London
Q120171120London
Q12017900Tokyo
Q220172200Tokyo
Q220172100Tokyo
Q220171000Tokyo
Q22017500Tokyo
Q220171900Tokyo
Q220171900Tokyo
Q220172000Tokyo
Q220174000Tokyo
Q220172100Tokyo
Q320171100Singapore
Q32017890Singapore

1 Reply

  • Greg_Deckler  Could you please take a look of the issue? and provide your suggestions on calculations or visualizations to handle this scenario.Also is there any viusualization with dropdown filter on column headers in powerbi.It can also help my case scenario.Please suggest