PowerBI: Urgent Help

[Chandramouli_BI]

There are 3 tables in the data. State, city & place. State->City->Place is the hierarchy order & have 1 to many relationships in the same order. In the PowerBI report I created 3 table visuals which will filter the data in the order State->City->Place. Now If I click on AP in state then City(VSKP & VZM) is filtered. Now I clicked on VSKP in city then Place table is filtered(RK Beach & Rushikonda). But the problem is AP in state table & VSKP in city table are not highlighted. I want to see AP, VSKP, RK Beach & Rushikonda highlighted. 

Excel File Link

https://docs.google.com/spreadsheets/d/122XHxy2Oh-D0NN54QhMCUHPV6nl6ZBhY/edit?usp=sharing&ouid=10810... 

PowerBI File Link

https://drive.google.com/file/d/12VdMBZe5szVFw8TD4cq777jqJRMy4-iw/view?usp=sharing 

[Pragati11]

Hi @Chandramouli_BI ,

Whenever you create a slicer visual in Power BI, there is a setting for Show Summary which you can use for this purpose.

For example, I created a multi-select slicer visual with turning this option on:

What is setting is doing, it is showing the selected value in your slicer against the slicer header:

(currently shows ALL as I haven't selected anything in the slicer)

Once I start selecting values, this value keeps on changing:

Just see if this option works in your case.

[Chandramouli_BI]

Hi @Pragati11 , I cannot use slicers to filter the data. I can use only tables because in the table there are other columns such as revenue etc... Client may sort the revenue column/any other column in the table & wants to check the lowest revenue wise buses. In this case he will click on that row only.

[Chandramouli_BI]

Thanks @Pragati11 for the reply. The requirement is I cannot use slicers as there are so many values. The client requirement is (Route->Trip->Stop hierarchy order) Particular route, in that route particular trip wise stops they want to see. So they want to know for which Route, which trip, the stops are showing. 

[PijushRoy]

Hi @Chandramouli_BI 

Please find the solution 
https://drive.google.com/file/d/1f-3D3x_mx0TWFzUXwyw5TDk0bw_qAfQR/view?usp=sharing 

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

Thanks
Pijush

[Chandramouli_BI]

Hi @PijushRoy, I cannot use slicers to filter the data. I can use only tables because in the table there are other columns such as revenue etc... Client may sort the revenue column/any other column in the table & wants to check the lowest revenue wise buses. In this case he will click on that row only.

[PijushRoy]

Hi @Chandramouli_BI 
I am not sure I understood the requirement correctly.
Can you please share an image of the output you are looking for?

[Chandramouli_BI]

The same output only but without using slicers,  by click thorughs. Client will check the table & he will click on any row in the table(Lets say low revenue row value. In this case he will click on it). Same for 2nd table, 3rd table etc. I hope I am clear with my query

[PijushRoy · Accepted solution]

Hi @Chandramouli_BI 

Please find the latest file (same link - page 2)
If you more table, same measure and visual level filter need to implement.

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

Thanks
Pijush

[PijushRoy]

Thanks @Pragati11 

I missed this feature.

Regards
Pijush