Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Everyone,
I wanted to create a slicer based on column name
I have created a visual based on two column 2021 and 2022 data, but I want a slicer name "2021" and "2022"
And when I click on 2021, it show visual values of 2021 Light Blue one and same for 2022 Dark Blue one
And If I don't click on anyone of slicer it shows the following
Thank you
Solved! Go to Solution.
@Anonymous
There are two methods.
First one which I recommend is to edit the code of the table in a way that makes it unpivoted.
The 2nd solution is to create a new unpivoted calculated table using dax (refer to following code). However, this code shall provide an idea on how to edit the code of the original table
NewTable =
UNION (
SELECTCOLUMNS (
OldTable,
"Category", OldTable[Category],
"Year", 2021,
"Total", OldTable[Total 2021]
),
SELECTCOLUMNS (
OldTable,
"Category", OldTable[Category],
"Year", 2022,
"Total", OldTable[Total 2022]
)
)
@Anonymous
There are two methods.
First one which I recommend is to edit the code of the table in a way that makes it unpivoted.
The 2nd solution is to create a new unpivoted calculated table using dax (refer to following code). However, this code shall provide an idea on how to edit the code of the original table
NewTable =
UNION (
SELECTCOLUMNS (
OldTable,
"Category", OldTable[Category],
"Year", 2021,
"Total", OldTable[Total 2021]
),
SELECTCOLUMNS (
OldTable,
"Category", OldTable[Category],
"Year", 2022,
"Total", OldTable[Total 2022]
)
)
Hi @Anonymous
you need first to unpivot the two columns using power query. The column names will become values of the Attributes column then you can use it for slicing
Hi @tamerj1 ,
I have created this table based on other tables values, I can't take this table to Edit Query mode
If there is a way, then kindly guide me
Thank you
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |