Hello in trying to add additional collapsible rows from another table but the values of 2nd table are not displaying correctly. Do they need to be in same table
I have a doubt here... I have a matrix table which has 3 levels of hierarchy in row that is : departments, Sourcing ranges and suppliers respectively.... In the column we have sales... Department has sum of all the sourcing ranges. sourcing ranges has sum of all the suppliers. Now I want to highlight the background of entire Rows like - Department (Dark gray) , Sourcing ranges (Light Gray) and the suppiers (white) - How should I do in powerBi?
Very well explained thanks 👍
Glad it was helpful!
Hello in trying to add additional collapsible rows from another table but the values of 2nd table are not displaying correctly.
Do they need to be in same table
How do you change the order of the column hearders? In your example make Mandalay the last column and Yangon in the first ?
I have a doubt here...
I have a matrix table which has 3 levels of hierarchy in row that is : departments, Sourcing ranges and suppliers respectively.... In the column we have sales... Department has sum of all the sourcing ranges. sourcing ranges has sum of all the suppliers. Now I want to highlight the background of entire Rows like - Department (Dark gray) , Sourcing ranges (Light Gray) and the suppiers (white) - How should I do in powerBi?
is it possible to edit totals and subtotals formula in matrix for preparing reports like P&L ?