Forum Discussion

Anika3186's avatar
Anika3186
Frequent Visitor
3 years ago
Solved

Metric - two different data in two visuals

Hello, I have a problem with two different visuals. I have a metric „% Share Total.Sls Preisklasse“. I have this metric once in a table and once in a bar chart (when I change from bar chart to line...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anika3186 ,

     

    Are the fields in the bar chart on the right exactly the same as the fields in the table visual on the left, or are there some more fields in the bar chart?

    It may be affected by other fields because of row context.

    Try turning the bar chart on the right directly into a table visual to check if 30.86% has changed.

    Row context in DAX - SQLBI

    Context in DAX Formulas - Microsoft Support

    Or does the bar chart contain visual-level filters?

    [% Share Total.Sls Preisklasse], [Total.Sls Preisklasse], and [Durchschnitts-VK-Preis SP] are measure, [Preisbandbreite] is a calculated column, right? 

    And [Preisbandbreite] is your x-axis in your bar char, right?

    Sorry, I need more details about your issue. Take care to protect your privacy.

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

Anika3186's avatar
Anika3186
Frequent Visitor
3 years ago

Hi Anonymous 

 

yes, the fields in the table chart are exactly the same as in the bar chart. The only difference: there is an additional legend in the bar chart (brand name) => this legend cannot be seen in my screenshots because I wanted to ensure the private policy.

 

Both visuals are already filtered by "Brand" in the main filters anyway. The strange thing, and I believe this is the cause:

If I completely remove the legend (Brand) from the bar chart and only use the main filter "Brand", then I don't see any differences. If I have the legend "Brand" in it, then I get these differences.

 

What can be the cause of the error in this case?

 


[% Share Total.Sls Preisklasse], [Total.Sls Preisklasse] are measures, [Durchschnitts-VK-Preis SP], Preisbandbreite] are calculated columns,

 

[Preisbandbreite] is on the y-axis
[% Share Total.Sls Preisklasse] is on the x-axis

 

Thanks

Anika