Matrix report

[Anonymous]

Hi All,

would need suggestion building the report. I have detailed report where need to show Customer,Material,Contract,Disributor details.

Customer Is the detailed report from where furthr drill down would happen to Material,Contract,Distributor etc.

customer report having customer name,address,contact details and similarly for Material having material ID,description and so on.

Do we have an option create a radio button option. For example, At the top,when user selects customer ,it should show customer detailed report, similarly for rest of the fields. 

[V-lianl-msft]

Hi @Anonymous ,

You can choose to use bookmarks or drillthrough according to your needs.

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

[Anonymous]

Thanks,

I would like to show a matrix report like below.

[Ashish_Mathur]

Hi,

Share some data, explain the business context and show the exact result that you are expecting.

[Anonymous]

I wanted to display the data like above .

[Ashish_Mathur]

Hi,

I dont think that is possible.

[Anonymous]

Hey @Anonymous 

My thoughts are to use a measure as your row in the matrix using the SELECTEDVALUE function with a slicer to change the matrix.

Alternatively, and probably better or easier, is to create each matrix for each radio button on a separate and use bookmarks to switch between pages. This is what I currently do with similar reports that I have created. It is much cleaner and neater and easier to use and manage.

Power BI Bookmarks: https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

You will create the button then under actions select the bookmark that corresponds to the page with the matrix set up under with the item that is named on the button.

If this helps please kudo.

If this solves your problem please accept it as a solution.