Forum Discussion

DavidB023's avatar
DavidB023
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 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

Need Help
  • v-piga-msft's avatar
    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

4 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    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's avatar
      DavidB023
      Helper III
      8 years ago

      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's avatar
        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