Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

PowerBI: Urgent Help

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 ...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi Anonymous 

    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

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
2 years ago

Hi Anonymous ,

 

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.

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.