Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
What I have right now is the visualization on the left side and I'm trying to accomphish the look of the one from the right side. As you can see right now there is the "Objective" for every quarter. However, if i'm trying to get the same looks as the one from the right I have to remove those reducdant column and only show the total for "Objective"
Thank you everyone in advance 🙂
Solved! Go to Solution.
@Anonymous - Perhaps have a look at The New Hotness - https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428
@Anonymous - Perhaps have a look at The New Hotness - https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428
@Greg_Deckler
I believe the information on your link is what i was looking for. However, could you explain me a little bit more regarding this dax
Custom Hierarchy =
{
("2019", "January", 1),
("2019", "February", 2),
("2019", "March", 3),
("2019", "April", 4),
("2019", "May", 5),
("2019", "June", 6),
("2019", "July", 7),
("2019", "August", 8),
("2019", "September", 9),
("2019", "October", 10),
("2019", "November", 11),
("2019", "December", 12),
("2020", "January", 1),
("2020", "February", 2),
("2020", "March", 3),
("2020", "April", 4),
("2020", "May", 5),
("2020", "June", 6),
("2020", "July", 7),
("2020", "August", 8),
("2020", "September", 9),
("2020", "October", 10),
("2020", "November", 11),
("2020", "December", 12),
("Other", "LY", 13),
("Other", "PY", 14)
}
I'm wondering how do I implement this on my report.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 17 | |
| 9 | |
| 8 | |
| 7 |