Show Values for a lock period in Power BI

[Anonymous]

Hi,

I new to Power BI, can anyone please hep me how to show values on a particular locak date.

There are 2 lock periods March and September. 

If user selects any month from March to August - Value should show for March only.

If user selects any month from September to February - Value should show for September only.

We a calendar Table and linked 1-Many relationship.

Please help me how to get this done.

Thanks in Advance.

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may use SELECTEDVALUE Function to get values of slicer. SWITCH Function or IF Function may return the month you need.

Regards,

Cherie

[Anonymous]

Hi,

I new to Power BI, can anyone please hep me how to show values on a particular locak date.

There are 2 lock periods March and September. 

If user selects any month from March to August - Value should show for March only.

If user selects any month from September to February - Value should show for September only.

We a calendar Table and linked 1-Many relationship.

Please help me how to get this done.

Thanks in Advance.