Help with waterfall chart

Hi jan0204 ,

In the absence of data, it is difficult to give specific solutions.

Please try the following:

1. Check Data Aggregation: Ensure that the measure for Total Variance is correctly aggregating data at the supplier level. Sometimes, aggregation issues can lead to inflated totals. Review the measure formula to confirm it's aggregating as expected.

2. Review Data Model Relationships: If your data model involves multiple tables, ensure that the relationships between the tables (especially those involving the supplier dimension) are correctly configured. Incorrect or missing relationships can lead to unexpected results in your visualizations.

3. Filter Context: Verify if there are any filters applied at the page, report, or visual level that might be influencing the Total Variance calculation differently when switching from category to supplier. Sometimes, hidden or unintentional filters can affect the results.

4. Data Type and Format: Double-check that the data types and formats for the supplier and category fields are consistent and correctly set up. Mismatches in data types or formats can sometimes lead to aggregation issues.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.