Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have this issue, I am having a Reveneue KPI thats comprised of 3 components(each is a separate measure). I want my bar chart to show the revenue as total in first layer of hierarchy. and want to display each component revenue at subsequent node of hierarchy.
like node 0 -> total revenue
node 1-> component 1 revenue
node 2-> component 2 revenue
node 3-> component 3 revenue
Please guide how can we do it?
Thanks in advance,
Sana
Solved! Go to Solution.
Thanks everyone, we acheived the solution using Switch function and added component type table as selector for selecting one component type or the other.
@sana_sagheer wrote:
I have this issue, I am having a Reveneue KPI thats comprised of 3 components(each is a separate measure). I want my bar chart to show the revenue as total in first layer of hierarchy. and want to display each component revenue at subsequent node of hierarchy.
like node 0 -> total revenue
node 1-> component 1 revenuenode 2-> component 2 revenue
node 3-> component 3 revenue
Please guide how can we do it?
Thanks in advance,
Sana
Maybe you can create a tricky measure to detect the hierarchy level and then show different measures accordingly. Just replace 1,2,3,4 with the measures in your case. See more in the attached pbix file.
Measure = SWITCH ( TRUE (), HASONEVALUE ( yourTable[node0] ) && NOT ( ISFILTERED ( yourTable[node1] ) ) && NOT ( ISFILTERED ( yourTable[node2] ) ) && NOT ( ISFILTERED ( yourTable[node3] ) ), 1, // in hierachy level 1 HASONEVALUE ( yourTable[node0] ) && HASONEVALUE ( yourTable[node1] ) && NOT ( ISFILTERED ( yourTable[node2] ) ) && NOT ( ISFILTERED ( yourTable[node3] ) ), 2, // in hierarchy level 2 HASONEVALUE ( yourTable[node0] ) && HASONEVALUE ( yourTable[node1] ) && HASONEVALUE ( yourTable[node2] ) && NOT ( ISFILTERED ( yourTable[node3] ) ), 3, // in hierarchy level 3 4 //in hierarcy level 4 )
Hmm, that's an interesting problem. I am not aware of a way to build a hierarchy with measures so interested in seeing if someone has an interesting solution to this. You could definitely do it in two different visualizations.
Thanks everyone, we acheived the solution using Switch function and added component type table as selector for selecting one component type or the other.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
2 | |
2 | |
2 |