Power BI Table

[Anonymous]

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!  🙂

[v-alq-msft]

Hi, @Anonymous 

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.

[amitchandak]

@Anonymous , 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

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428