Forum Discussion
SPMoore
Advocate I
Advocate ISuppress inline hierarchies
Hi everyone Just wondered if it is possible to suppress the inline hierarchies feature that was introduced in the August 2016 update? Taking my example, I have 2 fields on the X axis, day of wee...
AlexChen
Microsoft Employee
Microsoft EmployeeHi,
You can do that like following example. I assume you have a table like below.
Total amount of 2:00 is 100 and total amount of 1:00 is 50.
We can first create two columns of “DayOfWeek” and “Hour”.
Now you can create a clustered column chart with “Hour” and “DayOfWeek” in Axis.
Pay attention to the “Axis”. The first should be “Hour”, and the second is “DayOfWeek”.
Now you can Drill up to see “amount by hour”. Total amount of 2:00 is 100 and total amount of 1:00 is 50.
Best Regards
Alex
