Hi, I am trying to make a clustered bar chart in Power BI.
The situation is described as below :
I have a column "Value" which stores numeric value and I created another duplicate of this column (value duplicate). Same I have done for slicer and duplicated it.
The requirement is that in a clustered bar chart, I want one bar A should respond to slicer A and bar B to slicer B. So that I can compare two bars (values, duplicate value ) one in "New" and other in "old" for same Place(axis) )
The output I am getting: -
If the value selected in both slicers is same then only I am getting value. If I select New in slicer A and Old in Slicer B then clustered bar chart becomes blank. (for obvious reasons as both slicers have interaction activated with clustered bar chart) (Interaction between the slicer is disabled)
I have tried making all possible calculated columns and measure. And came to conclusions that it is not doable in power bi (might be I am wrong).
I have tried duplicating the data source as well and using one slicer from each data source, still didn't get the desired output.
Currently, I can make two different horizontal graphs instead of creating one clustered bar chart.