Forum Discussion
Matrix computed row - to show computed columns with several measures
Hi emmalim ,
Currently the measure is of text type, you need to convert it to a numeric type.
Please check the pbix file.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi emmalim ,
Please new a measure:
_Actual2 - _Plan2 = [_Actual 2]-[_Plan 2]output:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Anonymous Thanks for the support and explaination!
I encounter another issue whereby when I want to set the font colour based on value:
<0, show as red
>0, show as green
But the condition setting determine the column 'Actual - Plan' as Text:
I will need to set as below:
Appreciate your kind support to share the solution, thank you very much!
Hi emmalim ,
Please new a measure:
_Actual2 - _Plan2 = [_Actual 2]-[_Plan 2]output:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum