Individual charts for associated sub categories.

[kinkate18nic]

help with powerbi visualization. here is the scenario, I have L1 category and L2 sub categories, the structure is such that each L1 will have multiple L2 associated to it, Example: L1=Sale, corresponding L2 will have BLEspeaker, Wheadset, TWS etc along with their daily sales numbres. What I want is I will have a drop down list of L1, when i select a L1 from the list, I want to display all associated L2 sub categories in individual charts of their own, taking the same example, if Sale is selected in drop down, i need to show the total tickets for BLEspeaker, Wheadsetetc TWS etc in individual bar charts day wise.

I use a live connection, so creating additional columns is restricted and am looking for solutions without using small multiples.

Thanks

[lbendlin]

 am looking for solutions without using small multiples.

can you please elaborate?  small multiples help you to speed up your rendering queries substantially.

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[kinkate18nic]

The requrement is to have the charts with multiple color scheme. E.g BLEspeaker chart should have green color Wheadset-blue etc. I believe this is not possible in small multples.