Forum Discussion

sribmc's avatar
sribmc
Helper I
2 years ago
Solved

Dynamic table visible based on filter selection powerbi

Hi Team,   I have filters at top and need to get data table based on filter selection   A table contains aa,bb,cc,dd columns belongs to Atype Report and B table contains z1,z2,z3,z4 columns belon...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi sribmc ,

    In Bookmarks, choose bookmark Atype, choose "..." on the right side > Group:

    Drag bookmark Btype into group 1:


    Create and select the Bookmark navigator, in the Format navigator > Visual > Bookmarks > change "All" to "Group 1":

    And the final output is as below:

     

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Ray_Minds's avatar
Ray_Minds
Solution Supplier
2 years ago

Dynamic table visible based on filter selection powerbi
Step 1 - Imported the data as per given reference
Table : AType

Step 2
1.Created Calculated Table to use as Slicer in the Report
Calculation :-

Step 3 -Create Flag measure to use as Visual level filter

IsAtypeSelected = IF(SELECTEDVALUE(Slicer_Filter[Table Type]) = "AType", 1, 0)
IsBtypeSelected = IF(SELECTEDVALUE(Slicer_Filter[Table Type]) = "BType", 1, 0)

Step 4 Added table data in the Table Visualization

Step 5
Applied both measures like IsAtypeSelected and IsBtypeSelected in the Visual level
filter respectively the Table

For Table BType

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.