Power BI Bar Chart with Zero Values

[Yoshimitsu411]

Hello All

I have the following data tables

But the result in the bar chart is like this.

I have selected 'Show items with no data' on the X axis (categorical) but this doesn't work. 

I need to use the bar chart and only display Jan value as per the data table. The rest of the months need to show nothing.

Thank you for any assistance.

Yoshi

[Jimmy801]

Hello @Yoshimitsu411 

to me it seems af if you didn't connect both tables. So you could check the relationship between both tables.

BR

Jimmy

[Yoshimitsu411]

Both tables are connected. The month column from the Calendar table with the month column from the other table. The axis is showing this correctly.

It should only show one bar in the bar chart for January.

Thank you for your help.

[Jimmy801]

Hello @Yoshimitsu411 

but with what is shown in the Axis you are not able to determine wheter is connected or not. Because exactly this behavior happens when there is no connection between the tables. 

Could you post a screenshot of the relationship editor like so

Jimmy

[Yoshimitsu411 · Accepted solution]

Thanks for your help with this.

I found that because there was another direct relationship present on my data table, it made the relationship between the calendar data table and the main data table inactive. It seems this is not allowed.

I have fixed the issue with the bar chart, but now I need to fix the issue with creating multiple relationships on the data table.

Thanks again for your help.

Yoshi