Forum Discussion
Matrix report
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.
6 Replies
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.
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.Hi,
Share some data, explain the business context and show the exact result that you are expecting.
