How to create column as a input for report

[Anonymous]

Hi Team,

Please help on bellow issue. In my case i need to use column name as a filter in report.

1. Have input like bellow

2.Need out put report like bellow

3. And filter like bellow

When am select "Country" filter need to show data related to Country 

[ryan_mayu]

@Anonymous 

in the pq, select region, country and group , unpivot column

then you can use attribute column as a filter

[Anonymous]

Hi,

Thanks for your valubale information.

Is it support dircecty query also?

[ryan_mayu]

@Anonymous 

I am sure about this because I didn't try the direct import. Please have a try to see if you encounter any issues.

[amitchandak]

@Anonymous , You can import this table. Either you can convert to star schema and have dimension for region country and groups (one or more dimension based on need).

Or you can use them directly has filter.

You can put required column in table visual and it should do

[Anonymous]

Thanks for quick response.

Am new to Power BI, could you please give a one example with given data.