Forum Discussion

deb_power123's avatar
deb_power123
Icon for Helper V rankHelper V
5 years ago
Solved

How to format Table matrix cell in PowerBI?

Hi All,   what is the option to format the data values in a table matrix in PowerBI. My table matrix looks like the below screenshots.   If we can see in the below table matrix , the %attendance ...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi, deb_power123 

    Yes, power Bi has this format option:
    Check:
    format>>Field formatting>>Alignment>>left

     

     

     

    Is this the result you want? Hope this is useful to you

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

deb_power123's avatar
deb_power123
Icon for Helper V rankHelper V
5 years ago

Hi Thejeswar 

The problem is both % attendance and attendance are calculated columns and this doesnt show up in transformation tab.Try any calculated column , you cant unpivot ..is there a way to handle?

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

Hi deb_power123 ,

Shouldn't be a problem at all.

 

Just move the calculated columns to the Power Query Editor.

I mean created calculated columns in Power Query Editor. Then do the unpivot on those new columns.

It will work perfectly fine

 

Regards