Forum Discussion

rpinxt's avatar
rpinxt
Solution Sage
3 years ago

Column Chart value formatting problem

Ok mentioned this before and thought it was due to tabular editor but it was not.

Now using Field Parameters to switch between absolute values and percentage views.

 

On auto format my absolutes look like this :

I do not want this, I want to show like 153K instead of 0,15M (why is it even showing milions if even the entire column is not even close to 1 M ???!!)

 

So switched the labels to shows as thousand. Problem solved you would say...however....my % view now looked like:

 

So whats this?? and why? The tooltip nicely shows 21,96% but the chart shows 0,02K% (what is even that K doing there???)

🤔😖

 

Anybody that knows how to fix this anoying occurence?

Need Help

3 Replies

  • rpinxt's avatar
    rpinxt
    Solution Sage
    3 years ago

    Maybe nobody else has these problems?

    Could it be because of the setup of my model/sources that the value formatting behaves this strange?

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    3 years ago

    Hi rpinxt ,

     

    According to your description, you can implement custom units by creating measures to be displayed in tooltip. Refer to the following

    Amount_unitsr = 
Var TotalSale = sum(FactInternetSales[SalesAmount])
Var FinalSale = DIVIDE(TotalSale, 1000)
Var decimals = "0.0"
RETURN
FORMAT ( FinalSale, decimals & "K" )


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

    • rpinxt's avatar
      rpinxt
      Solution Sage
      3 years ago

      Thanks v-henryk-mstf but cannot have the correct format in tooltips.

      They need to be on the labels.

      I cannot ask my user to hover over the column if they want to know the amounts or percentages.

       

      The label needs to show the measure in thousands when absolute is selected and percentages when % is selected.

       

      (Ps. the picture with the tooltip is only there to show that there the format is correct but the label does not present the same value)