Forum Discussion

amalrio's avatar
amalrio
Icon for Helper V rankHelper V
5 years ago
Solved

Chart outcome as expected

Hello experts,    I have a chart rquirement that need to be achieve, below is the one I have currently, but I need it to be show like in image 2 whare you have two levels on x axis without drilling...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi amalrio ,

    Please sort the visualization by X-axis values, then disable the "Concatenate Labels" options like this:

    Here is the pbi file.

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please upload some insensitive data samples and expected output.

     

    Best Regards,
    Eyelyn Qin

amalrio's avatar
amalrio
Icon for Helper V rankHelper V
5 years ago

Hi amitchandak , 

 

Thanks for the reply, 

 

what I want to see in my graph is each year for instence say 2017, two bars one for Primary , and One for Ancilary, both Primary and Ancliary totals are made of other categories too. total ancilary(CatA, CatB) total Primary(CatC,CatD,CatE).. that is why bars are stacked, hope this explains, if not please let me know.