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 belongs to Btype report.

 

I have filter called select report which contains values of dropdown "Atype","Btype".When user selects A type I want to view table in below in tabular format:

 

Expected output :

 

1. Filter : Select Report dropdown: Atype

 

aa   bb   cc  dd 

1      4     7    8

2     5     9     10

3      6   11    12

 

2.Filter :Select Report dropdown:Btype 

 

z1   z2  z3  z4 

1      4     7    8

2     5     9     10

3      6   11    12

 

Also need on how to download when I click on download button on table.

Please help on above scenario ASAP.

  • 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.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi sribmc ,

    I'll address your first question first: how to toggle the display of table content. First of all, since you need to display two different data tables, you can't do it with just filter and slicer, you need to use bookmarks.
    First, open these sections in the View:


    Place your two table visuals overlapping top and bottom in the report:

    In Selection, Set Table A visible and Table B invisible, and set the bookmark Atype in that state:

    Then, Set Table B visible and Table A invisible, and set the bookmark Btype in that state:


    Add a Bookmark nagivator in Insert > Buttons > Nagivator, and the final output is as below:


    Then I don't quite understand what you mean by this phrase: "Also need on how to download when I click on download button on table.". This is the Power BI Desktop forum, there is no Download function or Download button in Power BI Desktop, could you please check if your question is correct, and perhaps you could attach your screenshot?
    Maybe the Download you are referring to is a built-in feature of a custom visual, but since the custom visual is not supported by Microsoft's official documentation, maybe you need to contact the custom visual's development team for support.

    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.

  • I want to hide book mark navigator here other than atype and btype they will other 4 bookmarks I want to hide 4 bookmarks and need to show only atype and btype how can we done this.

    Anonymous 

    • Anonymous's avatar
      Anonymous
      Not applicable

      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

    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.