Forum Discussion

mmossel's avatar
mmossel
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

Bar chart does not fill up all available space

Hi,   How can I make sure that the bar charts are more evenly distrubuted from top to bottom? The data is in "Values" and I have played around with all settings that have any effect (minimum catego...
  • v-jingzhang's avatar
    6 years ago

    Hi mmossel , there is another way to achieve a bar chart like below. Is this what you like?

     

    First create measures like below:

    M SfB Usage % = SUM(Sheet1[SfB Usage %])
    
    M Yammer Usage % = SUM(Sheet1[Yammer Usage %])
    
    M SPO Usage % = SUM(Sheet1[SPO Usage %])

    … And so on

     

    Second, create a measure list table and enter names in it:

     

    Then, use SWITCH function to create a master measure to be used as value in the chart.

    Usage % = SWITCH(SELECTEDVALUE('MeasureList'[Order]),1,[M SfB Usage %],2,[M Yammer Usage %],3,[M SPO Usage %],4,[M Exo Usage %],5,[M ProPlus Usage %],6,[M Teams Usage %],7,[M EMS total usage %],8,[M AAD %],9,[M Win 10 Usage %])

     

    Finally, put the master measure in the bar chart as value and measure name as axis, then you will get the bar chart.

     

    You can also change the color for each bar as you like. For more detailed guidance, please refer to this link https://radacad.com/dax-measure-in-the-axis-of-the-power-bi-report

     

    Best Regards,

    Community Support Team _ Jing Zhang

    If this post helps, please consider Accept it as the solution to help other members find it.