hide only measure with blank value in table visual

[powerbiexpert22]

i want to hide below "Display_Profit" measure in column which has blank value and show rest of the columns, if i put filter to ignore blank then it is making the whole table empty

Display_Profit =

VAR selDim = SELECTEDVALUE(Param_Dim[Param_Dim Fields])

var pos1=

SEARCH("[",seldim,1,0)

var length=LEN(seldim)

var tr=MID(seldim,pos1+1,length-pos1-1)

VAR allowed =

    COUNTROWS(

      FILTER(

        MeasureDimensionMap,

        MeasureDimensionMap[MeasureKey] = "Total Profit" &&

        MeasureDimensionMap[Dimension] = tr

      )

    ) > 0

// If no dimension selected, you may choose to show or hide; below shows when selDim blank

RETURN

--allowed

IF( selDim = BLANK() || allowed, [Total Profit], BLANK() )

[v-sgandrathi · Accepted solution]

Hi @powerbiexpert22,

Thank you @GeraldGEmerick for your reponse to the query and your contribution to the community.

In a Table visual, applying a filter to a measure for "is not blank” will remove rows, not columns. Since your Display_Profit measure is set to return BLANK() for the current selection, the filter removes all rows, making the table appear empty. The Table visual does not support hiding individual measure columns based on conditions.

Switch to a Matrix and add your measures as a column group, ideally using Field Parameters. Set Show items with no data to Off. When Display_Profit returns BLANK() in the current context, the entire ‘Display_Profit’ column will be hidden, but the other measure columns will still show. Your existing DAX, which returns BLANK() when not allowed, works correctly with this method.

If you need to keep a Table, here are some alternatives:

Use bookmarks or selection to toggle between different versions of the visual (with or without the Profit column). Use a placeholder such as “–” instead of BLANK() to mask values rather than hide them. For advanced users, apply Calculation Groups using the same Matrix method.

Documents you can refer:
Use report readers to change visuals - Power BI | Microsoft Learn
Show items with no data in Power BI - Power BI | Microsoft Learn

Thank you,
CST Member.

[v-sgandrathi]

Hi @powerbiexpert22,

We wanted to follow up to see if our suggestion was helpful. Please let us know how things are progressing and if you are still encountering any issues.

Thankyou.

[v-sgandrathi]

Hi @powerbiexpert22,

As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?
Thank you.

[GeraldGEmerick]

@powerbiexpert22 No real option to hide columns based upon something like that, just uncheck that measure in your slicer?