I have imported a excel spreadsheet that has different metrics (one being % of Revenue), and have added multiple slicers which works perfectly. Only issue is that when I select % of Revenue, it comes out as a decimal number. How can I rectify the below formula?
VAR CURRENTITEM = SELECTEDVALUE( ‘Detailed P&L’[Items (Normalized)] )
SWITCH( TRUE() ,
CURRENTITEM = “Total Revenues”, CALCULATE( [Subject IS], ‘Subject hotel’[Items (Normalized)] = “Total Revenues”) ,
CALCULATE( [Subject IS] , FILTER(‘Subject hotel’ , ‘Subject hotel’[Items (Normalized)] = CurrentItem)) )