Forum Discussion
PSan1979
5 years agoHelper II
showing dashboard
Hi Experts, I want to show my dashboard as below
- 5 years ago
PSan1979 , I doubt this kind of display. Use expand and concat labels, if that can work. Reverse Square Y with Year Qtr and month on Axis
- 5 years ago
Hey PSan1979 ,
you can achieve nested axis labels like this:
By adding the columns from your calendar table to the axis to form a hierarchy:
Disable the Concatenate labels property from the X axis formatting properties:
Exapnd the hierarchy of columns by using "Expand all ...", then sort the content of the visual:
First sort by axis labels instead of value:
Finally make sure the the labels are sorted ascending:
Hopefully, this is what you are looking for.
Regards,
Tom
amitchandak
5 years agoSuper User
PSan1979 , I doubt this kind of display. Use expand and concat labels, if that can work. Reverse Square Y with Year Qtr and month on Axis