FORMAT "Percent" with SWITCH changes visible rows in Table

[Frumpy]

Hi all,

I have created a SWITCH measure that shows values in a table based on the selection of a slicer with reporting periods:

SwitchReportingPeriod Decisions % Timely:= 

VAR SVReportingPeriod = SELECTEDVALUE('Calendar'[ReportingPeriod])

VAR Result = 

SWITCH(

    TRUE(),

    SVReportingPeriod= "Whole Year",

CALCULATE(

[Decisions % Timely],

Period[TypeID] = 1, ALL('Calendar'), CROSSFILTER(Period[Date],'Calendar'[Date],Both)

),

    SVReportingPeriod = "First four months" || SVReportingPeriod = "First eight months",

CALCULATE(

[Decisions % Timely],
Period[TypeID] = 2, ALL('Calendar'), CROSSFILTER(Period[Date],'Calendar'[Date],Both)

)

 )

RETURN

Result

This measure appears to be working just as I expect.

When the slicers has selected "Whole Year" (Period[TypeID] = 1), then the table looks like this:

When the slicer has selected "First four months" or "First eight months" (Period[TypeID] =2), the table looks like this:

Now since I want to show this measure formatted in percentage, I tried the following, both as a separate measure:

FORMATSwitchReportingPeriod Decisions % Timely:=
FORMAT([SwitchReportingPeriod Decisions % Timely], "Percent")

 
As in the Return statement of the measure itself:
RETURN FORMAT(Result, "Percent")

This both causes the table to show all reporting periods in the rows, but only show the corresponding values based on the slicer selection.

When selected Reporting Period = "Whole Year" (Period[TypeID] = 1):

When selected Reporting Period = "First four months" or "First eight months" (Period[TypeID] =2)

Now I am pretty new at DAX and PowerBI so I don't understand why this happens and how to fix it.

Hope someone can help! Thanks a bunch in advance!

[mlsx4]

Hi @Frumpy 

Why don't you change the format in Data View? 

And you click on the measure % Timely and button %

[Frumpy]

Hi mlsx4,

Thanks for your answer, sorry I failed to provide full information, but my data model is not actually in PowerBI, it's in SSAS. So unfortunately this formatting isn't an option. 

[Prateek97 · Accepted solution]

Hi @Frumpy ,

Can you try changing your formatted measure like below:

IF(

ISBLANK([SwitchReportingPeriod Decisions % Timely],

                 BLANK(),

FORMAT([SwitchReportingPeriod Decisions % Timely], "Percent")

)

Please mark as a solution, if it works.