Dashboard: Slicers can only use 1 number format

I am trying to create a dashboard for the stats of my agents. I have total of 5 stats and they are all in different number format. Decimal, time, and percentage. I did some research and I was aware that you cannot add column slicers only row so I unpivot my raw data using power query. So all of 5 stats are just in one column in different rows. This enabled me to make a slicers for all 5 stats.

I tried to classify the unpivoted raw data depending on their number format. That one seem to work but I can't connect 1 slicers for the month and employee name they must have one data source.


In Decimal Number Format:
Present
Score
Sales

In Duration Number Format:
Prod Time

Percentage Number Format:
QA

Problem:
1. When I build a pivot table and change the format, all stats have the same number format.

Goal:
Have 3 slicers. Employee Name, Month, Stats
Have 1 chart that would dynamically changed based on the slicers
Have 5 stats that have different number format (Decimal, Percentage, Time)

Is this possible without VBA?

Originally Posted by dflak

You will need VBA to change the axis values on the chart. However, there is an alternative design where you do not have to unpivot the raw data. You can use a regular pivot table, and named dynamic ranges to control the charts.

Are you interested and are you willing to accept a VBA solution to the display issue?

Sure thing but how about the slicers?

Originally Posted by dflak

I just noticed that you are using Excel 2003 - all bets are off.

I am using office 365

Originally Posted by AliGW

Then please update your user profile to reflect this. Thanks.

edited. Thanks!