Forum Discussion

BlackCat's avatar
BlackCat
Icon for Helper III rankHelper III
5 years ago
Solved

Can't change decimal in format

I am trying to change the decimal in one of my columns, I've highlighted that it should read 10,416.67 but instead as you can see in my attachment is reading $1,041.667. I've tried to change the deci...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi BlackCat ,

     

    It looks like you want to divide this value further by 100 to get that format. Is it right?

    Something like below:

     

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi BlackCat ,

 

As parry2k  mentioned, it was not a decimal data-type format issue, the issue was with the measure.

You needed to divide your final value in the measure by 100 so that the displayed data format is to your requirement. The data-type format in power BI was correct from the starting.

 

Thanks,

Pragati

BlackCat's avatar
BlackCat
Icon for Helper III rankHelper III
5 years ago

Yes correct it was a measurement issue, when divided by 100 it was corrected. With the middle visual, I cannot provide "Totals" for some reason this is also an issue, please see attached. Thank you in advance.

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    5 years ago

    Hi BlackCat ,

     

    What do you mean by you couldn't provide totals? Can you please be more clear?

    • BlackCat's avatar
      BlackCat
      Icon for Helper III rankHelper III
      5 years ago

      If you look at my last column subtotals they are returning the value of each column and not the total month over month. For instance The Division Learning should be totaling the entire row.

      • Pragati11's avatar
        Pragati11
        Icon for Super User rankSuper User
        5 years ago

        Hi BlackCat ,

         

        Turn on ROW SUBTOTALS as shown below: