Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have data like this.
Category | Brand | Manufacturer | Value |
C1 | B1 | M1 | 10 |
C1 | B2 | M2 | 20 |
C2 | B1 | M1 | 30 |
C2 | B2 | M2 | 40 |
C3 | B1 | M2 | 50 |
I have a dropdown with values "Brand","Category","Manufacturer".
When user selects Category, bar chart should be by Category and similar way for other.
How to achieve this without changing any data format like unpivoting !
Solutions without bookmarks are preferred as my client is not very satisfied with that feature . ( I know its kind of strange)
Solved! Go to Solution.
Hi @nithin_v,
You don't want to change the any data format, maybe you want to use the original table to create another table, you can create a new table to get expected table.
First, I create a new table by clicking "New table" under Modeling on Home page, then type the formula below.
Table = UNION ( SELECTCOLUMNS ( Table1, "Level", Table1[Brand], "Value", Table1[Value] ), SELECTCOLUMNS ( Table1, "Level", Table1[Category ], "Value", Table1[Value] ), SELECTCOLUMNS ( Table1, "Level", Table1[Manufacturer], "Value", Table1[Value] ) )
Then type another table, and create relationship between them. Create a slicer including Level[Level], you will get expected result.
In addition, there is no slicer based on column, so we have to put all the X-axis value in one column, otherwise we can't get result. And there are two similar threads for reference.
https://community.powerbi.com/t5/Desktop/Dynamic-Column-Based-on-Slicer-Selection/td-p/81126
https://community.powerbi.com/t5/Desktop/Dynamic-change-in-X-Axis/td-p/86167
Please download the .pbix file for detailed information.
Best Regards,
Angelia
Hi @nithin_v,
You don't want to change the any data format, maybe you want to use the original table to create another table, you can create a new table to get expected table.
First, I create a new table by clicking "New table" under Modeling on Home page, then type the formula below.
Table = UNION ( SELECTCOLUMNS ( Table1, "Level", Table1[Brand], "Value", Table1[Value] ), SELECTCOLUMNS ( Table1, "Level", Table1[Category ], "Value", Table1[Value] ), SELECTCOLUMNS ( Table1, "Level", Table1[Manufacturer], "Value", Table1[Value] ) )
Then type another table, and create relationship between them. Create a slicer including Level[Level], you will get expected result.
In addition, there is no slicer based on column, so we have to put all the X-axis value in one column, otherwise we can't get result. And there are two similar threads for reference.
https://community.powerbi.com/t5/Desktop/Dynamic-Column-Based-on-Slicer-Selection/td-p/81126
https://community.powerbi.com/t5/Desktop/Dynamic-change-in-X-Axis/td-p/86167
Please download the .pbix file for detailed information.
Best Regards,
Angelia
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |