Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Thank you very much for this idea!
However, I am quite new in DAX. I tried to merge those metrics:
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 🙂
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.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |