Multiple values in power pivot tables

[Koxeida]

Hey guys,

I'm just wondering whether it is possible for pivot tables to show multiple values in a single Value cell? For example, one value is shown through "Number value" while the other value is shown through "highlighting" the cells.

I know Tableau can do the function but is Excel capable of doing something similar? I'd appreciate it if you guys can point me to the right direction. Thanks!

 

[Matt Allington]

I don't understand what you mean by highlighting. Are you saying something like hover the mouse and see a tool tip? You can do this in Power BI but not in Excel.

 

[Koxeida]

Hey Matt,

What i meant by this is that let's say you have volume and sales price. I want a single value cell of pivot table to show both volume and sales price data without concatenating the results. Let's say volume is represented by the data bar visual while sales price is indicated in numbers.

Something along that line.

 

[Matt Allington]

Ok, so no change from my previous comment. You can do this in power BI but not in Excel

 

[Koxeida]

Ah I see. Thanks for the info!