Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Incorrect total in bar chart

Hi everyone, We have a bar chart like:  The Total Data Label is showing a SUM of the values, however, if we change the chart type to Matrix, we see this: Which is what we...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi Anonymous

     

    You can create a measure as:

    Total = 
VAR __table = SUMMARIZE('Table1',[Teanologia],"_value",sum(values))
RETURN
IF(HASONEVALUE(Table1[Teanologia]),sum(values),SUMX(__table,[_value]))

     

    Best Regards,
    Link

     

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

Sandeep_PowerBI's avatar
Sandeep_PowerBI
Frequent Visitor
3 years ago

Hi Team,

 

I am getting incorrect values in Bar chart. Earlier same incorrect totals are showing in matrix visual then have written HasoneValue Dax with SUMX and corrected. Now i am getting values error in Bar chart... In tooltip it showing correct value but data label showing wrong value. How to correct it? Attahced screenshot for reference...

When i am changing the slicer, as per table visual its correct but bar chart showing all incorrect values data lable. but if i take cursor on bar it hover showing right values... Feb - correct value is 0.03 but in bar its showing 0.028

 

Thank in advace!

 

Sandeep