Value Headers

[Treyson]

Hello,

I am creating a table that shows YoY revenue for different lines of business. I have set each LOB to have their own column of revenue information and I want to show that information with 2015 and 2016 next to each other, rather than the buckets sitting under seperate year buckets. I am explaining it poorly so here is the functionality with pivot tables.

Currently my Power BI matrix looks like the pivot table below. My revenue type value headers are below the year, which makes YoY comparisson difficult.

Within pivot tables, I can simply move the order of the column headers so that my years are below the value headers. Is there a similar functionality within Power BI that allows me to put this year header below my value headers?

[v-sihou-msft]

@Treyson

In Power BI, the measure name always appear under the field you put in Column Pane. We can't have it measure names appear above the column group like pivot table. This behavior is by design.

Regards,

[Treyson]

@v-sihou-msft Are there plans to add this function to Power BI? It seems that if anything this design limits the tool.

[v-sihou-msft]

@Treyson

I don't know if this kind of feature is on roadmap. I suggest you submit a feature request on Ideas: https://ideas.powerbi.com/forums/265200-power-bi

[ankitpatira]

@Treyson Using matrix visual for power bi you can swap around fields for columns which will give you what you're after.