Using Excel records, how to create a POWER BI REPORT outlining each columns contents upon filters

[anirdesh8563]

I have excel file of Cars data.

In POWER BI Report, if user selects/filters either Make or Type or Origin, all pertinent information outlines in total 9 text block ( there are 9 columns).

[PhilipTreacy]

Hi @anirdesh8563 

1. In Excel, create a table from the data
2. Load the data into PBI using Power Query - get data from table
3. Create a table visual and add the data columns to it
4. Create slicers for the Make, Type and Origin.  Filtering with these will display the data as you want.  Bear in mind that each slicer's selection will add (further filter) the selections made in any other slicers.

Regards

Phil

[anirdesh8563 · Accepted solution]

Thanks for your prompt response and reply. It helped me to get going.