Display two diferent data type in matrix component

[railtons]

Hi team,

I dont have a lot of experience in Power Bi and I have one problem like this:

I need to create a view where I will display information grouped by ‘Planned’, ‘Real’, ‘Work to be done’, ‘Projected’, and the difference between the planned and projected values. This difference must be in percentage.

I am trying to use the matrix component, but since I have different value types (decimal and percentage), could you help me understand how I can display these two different value types in the same component?

I also tried to display the percentage information in a different component, like a table. However, when I click on the line in the Matrix component, the value is not displayed in the second table because my matrix does not display the ‘Écart %’ type

Thanks for the help!!!

[Anonymous]

Hi @railtons 

Based on your description, you can consider to use dynamix format or calculation group, for the dynamic format, you can custom the data format of the measure, you can refet to the following link.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings#create-dyna...

Deep dive into the new Dynamic Format Strings for Measures! | Microsoft Power BI Blog | Microsoft Po...

Create calculation groups in Power BI - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

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

[Ritaf1983]

Hi @railtons 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly