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.
Good evening,
Below is a table that they would like to be placed in Power BI as is. I have tried using the table visualization but not successful. Any suggestions or tips would be greatly appreciated!
Thank you all for your time and effort! 🙂
Hi, @Congamond
Based on your descirption, I think matrix visual may help in this scenario. The matrix visual is similar to a table visual. A table visual supports two dimensions and the data is flat, meaning duplicate values are displayed and not aggregated. A matrix visual makes it easier to display data meaningfully across multiple dimensions -- it supports a stepped layout. The matrix automatically aggregates the data and enables drill down.
For further information, please refer to the following document.
Create matrix visualizations in Power BI
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Congamond , I doubt, you can get these in one table
It also seems like a case of measure split. You have to create a table like
union(
summarize("Measure","Share of Voice", "YTD",[Share of Voice YTD], "LYTD",[Share of Voice LYTD], "Change %",[Share of Voice %]),
summarize("Measure","SOV Rank", "YTD",[SOV Rank YTD], "LYTD",[SOV Rank LYTD], "Change %",[SOV Rank %])
)
or Follow the blogs from Paul and Greg
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39773011-hybrid-table
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |