Forum Discussion

Helper III

8 years ago

Solved

Proportional Histogram

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 prop...

Need Help

v-piga-msft
8 years ago
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

v-piga-msft

Resident Rockstar

8 years ago

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