Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.