Merge two visuals with different measures and export table with formatting colors

[RajaKoteru]

HI,

I am trying to merge two differnt visuals one with direct data and one with summarized totals data as shown below.

What are my options to merge and export with formatting colors

[Anonymous]

Hi @RajaKoteru ,

I am not sure how your source data table is designed, here is my sample.

The source data table.

The two matrixes use different measures.

Combine them into a matrix that uses the two measures at the same time.

In this way, two measures can be displayed in a single matrix.

However, conditional formatting cannot be automatically applied to exported data, and you will need to reset the conditional formatting in Excel.

Please refer to the following similar thread.
Solved: How to apply conditional formatting while exportin... - Microsoft Fabric Community

If this does not meet your needs, please provide sample files. We can better understand the problem and help you. 

Please see the attahced pbix for reference.

Best Regards,
Dengliang Li

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