Proportional Histogram

[DavidB023]

Hi everybody,

I want to create an histogram with two columns like that :

Firstly,  I don't success to create this two columns on the same histogram.

Secondly, I need to have proportionnal ratio on histogram. For example, pink row show 62.17 and the other 106.58. But the 62.17 is so big than the other and its not logical on reality.. does anybody can explain me, if it is possible, how I can resolve my problem and have two proportionnal histogram.

Thanks

DavidB023

[v-piga-msft]

Hi @DavidB023，

Which chart did you created?

I have made a test with the Stacked Column chart with Power BI Desktop April version, everything works as expected.

If it is convenient, could you share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

Best Regards，

Cherry

[DavidB023]

@v-piga-msft Thanks for your time, so I put as an attachment an example of data. These data are like mine and like I said previously, I want to have two columns on one graph if it is possible, and I want a proportionnal repartition. On my example, you can see that for a same kind of category like E, the forecast is bigger than the real on the figure but not on the visual.

That create an unlogical visual for my dashboard..

https://1drv.ms/u/s!AlpYVjQtU7WhiS1xfWK_pBilOtGO

Best regards

DavidB023

[v-piga-msft · Accepted solution]

Hi  @DavidB023,

---

These data are like mine and like I said previously, I want to have two columns on one graph if it is possible, and I want a proportionnal repartition. On my example, you can see that for a same kind of category like E, the forecast is bigger than the real on the figure but not on the visual.

Firstly, if you want to put two columns on one graph, you need to change your data structure in Query Editor.

Then  I suggest you create the visual with Stacked column chart. 

If you create the 100%  Stacked column chart which is allocated by percentage so it will show 'category like E, the forecast is bigger than the real'.

Reference: test pbix file

Hope it can help you !

Best Regards,

Cherry

[DavidB023]

@v-piga-msft

It's like I want, thanks very much !

Best regards

David