Bar charts Edit interactions.

[Ajithrjaa]

Hi Team,

Could you please suggest a better approach to this Requirement.

I have fields Product Category, Product subcategory, and Product Name. If I have selected Product Category as a bikes my bar chart is filtered Product subcategories showing as Road bikes,  Mountain bikes, and touring Bikes.

But if I'm selected on Product subcategories in Road bikes the filter reset in Product subcategories.

whenever I am selected by using ctrl in the keyboard my case works what I'm expecting output like 

Regards,

-Ajith Reddy

[AjithReddy049]

@Anonymous @Priya1969 @amitchandak 

Pbix file : https://1drv.ms/u/s!Aut620beS3BbgQcfP-Z-_qwwSnnQ?e=cmbdYt

[Anonymous]

Hi @Ajithrjaa,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Priya1969]

Please share sample data, I can try.

[amitchandak]

@Ajithrjaa , if you want to select more than one value, you have select with Ctrl+ Click, That is what you are already doing.

In case you want a filter, instead of a highlight, you can change interactions https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions