BarChart Limitations

As with all custom visuals developed for Power BI, BarChart has the following limitations due to Microsoft's policies:

• Renaming columns and tables within the Power BI report is not supported. These names must match those used in the underlying data source. For SSAS models, the names should align with the entities visible in your model or the report’s Fields sections.
• The characters '[' and ']' (brackets) are not supported in measure names.
• The character '.' (dot) is not supported in table names, although it can exist in schema names. If your table name contains unsupported characters, consider creating a view on top over the table that adheres to the required format and use that view for write-back functionality.
• You can only display 5000 records at once, it is the default value set by Microsoft.
• The DAX Expression COUNTROWS(Table) is not supported for write-back.
• Non-writable views that serve as a data source for fact tables are not supported for write-back. Consider materializing your view into a physical table or simplifying the view’s complexity. Alternatively, you can create INSTEAD OF INSERT | UPDATE triggers to handle the operation. Typically, non-writeable views are views that contains complex SQL queries with multiple joins, CASE statements in WHERE clauses, CTEs (Common Table Expressions), and aggregations. You can test your view by duplicating it under a different name and executing an INSERT statement against it.
• If you’re using the on-premises Power BI Report Server, ensure you have at least the January 2019 version, along with Power BI Desktop 2019 January or more recent versions.
• When using slicers, page-level, report-level, or visual-level filters, it is essential to also incorporate the SmartFilter helper visual. See Importance of SmartFilter Helper Visual for more information.