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.
Hi guys
I hope this is a real issue and not only my lack of understanding power bi.
Aim:
I want to create a chart with drilldown function where on the upper level the values on the x-axis display categorical data (for example "monday-friday", "monday-sunday", "saturday-sunday"). On the second level (if you use the drilldown function) the values of the x-axis should display continous data (e.g. time value of every 15min of the day).
So this chart allows to switch from e.g. the market reach of some channel per category ("monday-friday", ...). To the evolution of the market reach over the day for the selected category. That for itself is no problem (see the examples below).
Problem:
As you can see the values of the x-axis in the upper picture (the bottom level of the drilldown chart) are displayed like categorical data, i.e. every value is displayed. This results in a chart where you have to scroll to the right what is absolutely not necessary and undesirable. My guess is that the bottom level x-axis is treated like the upper level x-axis - as categorical (This assumption is strenghend through the fact that it is not possible in this example to switch the type of the x-axis of this chart from categorical to continous).
Question:
Is there a possibility to treat the upper level x-axis as categorical and the bottom level x-axis as continous?
Thanks and Regars
Lukas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.