Forum Discussion
Display two diferent data type in matrix component
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!!!
2 Replies
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
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.
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.
