Forum Discussion
Proportional Histogram
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 !:smileytongue:
Best Regards,
Cherry
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
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
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 !:smileytongue:
Best Regards,
Cherry
