Two filters on one dataset in one visual

[Schmiffel]

I have one dataset with 5 different percent categories.  I'm trying to make a stacked bar chart to include 4 of the percent categories, with a line value using the 5th.  Is there a way to filter the data twice on the same table to achieve this?  Or do I need to manipulate my raw data in excel first?

[Anonymous · Accepted solution]

Hi @Schmiffel,

Perhaps you can enter to query edit to do 'unpivot columns' on these percent categories, then you can use a filter to filter across multiple fields.

Unpivot columns (Power Query) - Excel (microsoft.com)

Dynamic Attributes In A Power BI Report | P3 Adaptive

Regards,

Xiaoxin Sheng

[parry2k]

@Schmiffel can you share sample raw data with the expected output?