Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I am having a table as show below in Power BI Desktop Canvas,
I have set a filter on "Segemt" column in the Canvas. Now, If i select "Gift" in segment then only Columns "Store", "Segment", "Mug", "Pen" and "Doll" should be shown. Similarly, When I select "Stationary" then columns "Store", "Segment", "Pen" and "Note" only should be displayed and remaining columns should be hidden.
I have'nt got any blogs or post in online to perform the above functionality. So, I am posting here to know whether is there a way to do it in Power BI.
Thanks in advance.
Regards,
Mohanraj
Solved! Go to Solution.
Hi, @Anonymous
Based on your description, it is unavailable to use the origin table data in the scenario. As a workaround, you can operate as following steps to achieve your requirement. I created data to reproduce your scenario.
You can click ‘Edit Query’, go to Query Editor, choose ‘Transform’, replace ‘0’ with ‘null’ in the table, click on 'Store','Segment' columns,click ‘Unpivot other Columns’, choose ‘Unpivot Other Columns’, click ‘Close and Apply’.
Finally, you may use the matrix visual to show the result and configure as follows.
If I misunderstand you thought, please show me your expected output. I am glad to solve the problem for you.
Best Regards,
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
Based on your description, it is unavailable to use the origin table data in the scenario. As a workaround, you can operate as following steps to achieve your requirement. I created data to reproduce your scenario.
You can click ‘Edit Query’, go to Query Editor, choose ‘Transform’, replace ‘0’ with ‘null’ in the table, click on 'Store','Segment' columns,click ‘Unpivot other Columns’, choose ‘Unpivot Other Columns’, click ‘Close and Apply’.
Finally, you may use the matrix visual to show the result and configure as follows.
If I misunderstand you thought, please show me your expected output. I am glad to solve the problem for you.
Best Regards,
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @v-alq-msft for the quick workaround. To certain extend the solution was useful.
Hello @Anonymous ,
Can you provide basic structure involved for this visual?
If the solution posted by @v-alq-msft didn't work, please let me know if I can be helpful.
Thanks.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |