Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help on stacked column chart legend data

Hi,   i have two tables called "movecount" and time dimenssion table (which is created from sql query) :  this table data is coming from postgres :  Country operator S_name arrival_time ...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, Anonymous 

    According to your sample picture, it seems that the zero calls are displayed in your column chart but their data label disappeared because its color is white, you can try to change the data label color of this column chart to a dark color to make it display:

     

    https://www.c-sharpcorner.com/blogs/data-labels-and-axis-style-formatting-in-power-bi-report

     

    If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

    How to Get Your Question Answered Quickly 

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

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

dkaushik's avatar
dkaushik
Resolver II
5 years ago

Hi Anonymous ,

 

You can include the blanks by enabling "Show items with no data". Click on the downward arrow next to your axis field. Seel below:

 

Also, you can rename the field under "Values" to your desired name instead of auto generated total_S names and upon right clicking on that field you can switch btween multiple options like average, count, sum etc.

 

Thanks,

Dheeraj

 

Please mark as solution and give kudos if this helps you.