Make a Month column values blank in a table when selected values on slicer is "YTD", "QTD"

[Anonymous]

Hi Guys,

I have a requirement where I want to display Month Column as Blank when the slicer selection is "YTD", "QTD", but show months as it is when other values in the slicer are selected. I am looking for a Dax command to achieve this. The Goal here is to get summarized value when "YTD", "QTD" is selected making the month columns blank, and showing them again when other slicer values are selected.

Something this way, but it is not working.

Date-MMM = IF(SELECTEDVALUE('Measures Table'[Measure Select]) in {"YTD","QTD"} ,"",FORMAT(FRD_MR[Fiscal Date],"MMM-YY"))

Any help would be highly appreciated.

Thanks in advance

[amitchandak]

@Anonymous , You have to create a measure like

Date-MMM = IF(SELECTEDVALUE('Measures Table'[Measure Select]) in {"YTD","QTD"} ,"",FORMAT(max(FRD_MR[Fiscal Date]),"MMM-YY"))

or

Date-MMM = IF(SELECTEDVALUE('Measures Table'[Measure Select]) in {"YTD","QTD"} ,blank(),FORMAT(max(FRD_MR[Fiscal Date]),"MMM-YY"))

New column will not work as column can not take selected value

[Anonymous]

Thanks @amitchandak ,

It is working, but the challenge here is I want to add this measure in the Rows Section of a Matrix. Unfortunately, It is not letting me add the new measure in the rows section. Sorry I didn't mention it earlier.

Thank You

[lbendlin]

an empty string "" is not the same as BLANK(). Please provide sample data in usable format and show the expected outcome.

[Anonymous]

Hi @lbendlin ,

Below is a sample scenario how I want the interaction to be:

I need help in writing a DAX for Column Month: Which will dynamically change values based on the slicer selection. Basically the values of Month Column should change to Blank() or "". But it is not picking values from the slicer selection with the Dax that I am using.

Thanks