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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion
    2 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        PijushRoy
        Icon for Community Champion rankCommunity Champion
        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