How to merge two visuals in Power BI

[aurora90]

HI Fellows,

I wonder, how can I merge two same-looking power bi visuals (pivot tables).

The difference between them is that they are using different measures and background formatting rules.

If not possible, is there an option in Power BI not to use the headers? I will crop the visuals and make the illusion of a merger.

[aurora90]

Thank you very much for this idea!

However, I am quite new in DAX. I tried to merge those metrics:

Value =

Var Result= ROUND(AVERAGE(KPIs[Numerator])/AVERAGE(KPIs[Denominator]),3)

Var Result2=ROUND(SUM(KPIs[Numerator]),3)

Return

IF(ISBLANK(FORMAT(Result,"Percent")),"N/A",IF(MAX(KPIs[KPI])<>"Unreconciled Balance Sheet Accounts in USD", FORMAT(Result,"Percent"), FORMAT(Result2,"Currency")))

I am eceiving error: 

When I gave up on the Currency FORMAT, it works, but $ Values are displayed as a General number. How to fix this?

Thanks for all ideas 🙂

[KNP · Accepted solution]

You could probably change your measures and formatting to calculate differently based on the KPI or whatever value required and then just use the one matrix but based on the question you asked.

There's no way that I'm aware of to turn off the headers but you can fake it by changing the formatting of the column headers. Set the text colour to the same colour as your report background. Make sure when you overlap the visuals that the correct one is on top by adjusting the order of the visuals in the selection pane. 

This should allow you to achieve what you want.