Forum Discussion
Clustered Bar Chart Not Showing 0%
Hi, hlawrepbi
This has nothing to do with your measure.
To avoid chart Not Showing 0%,you need to create a separate table for the field you apply to the axis
Please try follow steps:
1. create a seperated table which only contains the axis field (location).
Location table = DISTINCT('Table'[Location])2.building relationships between your location table and original data table
('Table'[Location] <--->'Location Table'[Location] )
3.using the new field 'Location Table'[Location] replace the original axis field 'Table'[Location]
If I misunderstand your requirement or it doesn't work, please share a demo pbix file for testing.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your reply amitchandak! In this case, removefilters would remove some of the needed filter context that I need to perform the calculation, since the numbers vary by each location (which is the axis field). Just to be sure, I tried it out, but the entire chart was blank.
Community SupportHi, hlawrepbi
This has nothing to do with your measure.
To avoid chart Not Showing 0%,you need to create a separate table for the field you apply to the axis
Please try follow steps:
1. create a seperated table which only contains the axis field (location).
Location table = DISTINCT('Table'[Location])
2.building relationships between your location table and original data table
('Table'[Location] <--->'Location Table'[Location] )
3.using the new field 'Location Table'[Location] replace the original axis field 'Table'[Location]
If I misunderstand your requirement or it doesn't work, please share a demo pbix file for testing.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.