Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
As per title, i would like various levels of a hierarchy I use as Row Header for a matrix to be concatenated when drilling down.
1. Starting Point
2. Current outcome
3.Desired outcome
(Image 3 is just a reference I made up using paint, but it should be enough to get an idea of what I would like to accomplish.)
Based on what I've been able to gather thus far, this might not even be possible to do.
Could someone confirm/deny this?
Solved! Go to Solution.
Use concatenate() and combine those two columns later add to the matrix after the top category
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Use concatenate() and combine those two columns later add to the matrix after the top category
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Do I need to create a measure using CONCATENATE() or do I need a calculated column?
Because I am not able to create new calculated columns as the data I'm using comes from a direct connection to a live dataset.
you need calculated column
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
User | Count |
---|---|
85 | |
82 | |
66 | |
52 | |
48 |
User | Count |
---|---|
100 | |
49 | |
42 | |
39 | |
38 |