Dynamic table visible based on filter selection powerbi

[sribmc]

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.

[Ray_Minds]

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.

[sribmc]

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 · Accepted solution]

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.

[Anonymous]

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.

[sribmc]

need help asap