Hierarchical visual

[Sudhavi_84]

Hi I have like 100000 rows which has duplicate values in few columns. Currently it is diifficult to read/understand the data for end user.
I can transform the data but still data will be huge and difficult to understand/read the data.

Column A- Column C has duplicate values but Column D has unique values, column D and E with Unique values and again Column F with duplicate values.

I want to create something like hierarchal visual. I don't know I am using correct word or not but something like that.
So when I select 1 from ID it should display ABC as Prj and Loc1 as Loc in visual(May be card/multi card visual not sure)
and need other drop down control related so that I can select Status 1 or Status 2 from Prjstatus dropdown..
When I select Status1 it should display as Gate1 for description

May be we need more visuals in page.

Reason behind this is we have like 100000 Rows and 50 Columns they want to visualise as table which is difficult to read because of duplicates in few columns.

Any solution for this please?

[Fowmy]

@Sudhavi_84 

You can use Slicer visual in Power BI to achieve the results. Each required column can be assigned to each Slicer and arrange in the hierarch you mentioned from left-right may be so users will start filter on each slicer and see the correct filtered values.

[Sudhavi_84]

Thanks @Fowmy fpr respoding

Yes but it will show all the duplicate or repeated data as well isn't it? How can we acheive only by showing one row of data if there are duplicates.