Forum Discussion
Show vertical bar chart without grouping items
Hi Anonymous ,
The easiest way to do this is to go to the Query Editor, select all columns, and then select Unpivot Columns.
However, you can also perform this operation in DAX, you can perform the following formula
1. Create calculated table.
Table 2 = UNION( SELECTCOLUMNS( 'Table', "Year",2021, "Value",[Year 2021]), SELECTCOLUMNS( 'Table', "Year",2022, "Value",[Year 2022]), SELECTCOLUMNS( 'Table', "Year",2023, "Value",[Year 2023]), SELECTCOLUMNS( 'Table', "Year",2024, "Value",[Year 2024]), SELECTCOLUMNS( 'Table', "Year",2025, "Value",[Year 2025]))2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous ,
If I understand your question, you are looking for something like this?
Create a measure for SUM () of each year.
YR 2021 = SUM(TableT[Year 2021])
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Thanks for the reply but I need it not to be grouped together as shown but seperated under x-axis categories for each year.