Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a requirement to create 'clustered column chart'. In that I have to have 2 columns at the X-axis.
Ex: On X-axis I should have Region and City. Cities should be grouped under respective region and show sales data.
Please help me with this.
Thank you.
Hi @Kap,
here is an example of what @Greg_Deckler tolds you.
(I've used state/city to simplify)
I've changed the "Date Category" of State and City to make them more efficient.
#I'M Not An Expert#
With a clustered column chart, if you put two things in the x-axis, you will be able to "drill into" the columns. Alternatively, place Region in x-axis and Cities in Legend, then you will get both on the x-axis grouped by region.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |