I have bookmark page, “Sourcing area pie chart”, that has pie charts for all sourcing areas in our system. All the pie charts are filtered per sourcing area under “Filters” for the visuals. I have a measure that is dynamically adjusted.

For example if we have a pie chart filtered for sourcing area Y,

The user selects growing season X and there is data for Y in growing season X, then the title should show,

“Input cost % for Y in X” – case A

and in the case that there is no data for Y in growing season X it should show,

“No data available for Y” – case B

However, currently the measure only works with case A, and case B not. The issue seems to stem from if there is data for a sourcing area for a specific growing season. If there is, the measure works as intended, if there isn’t it does not work.

I am not sure what the issue is and how to fix it. I have made sure the slicer for sourcing is not affecting the pie chart, but the issue persists.

Measure used:

_SourcingareaPietitle =

IF(
    ISBLANK(MAX('CAD$,T,Ha'[Growing Season])) || 
    ISBLANK(SELECTEDVALUE('CAD$,T,Ha'[Delivery period])) || 
    ISBLANK(SELECTEDVALUE('CAD$,T,Ha'[DataType])), 
    "No data available for " & 
    SELECTEDVALUE('CAD$,T,Ha'[Sourcing Area], MAX('CAD$,T,Ha'[Sourcing Area])), 
    "Input cost % for " & 
    SELECTEDVALUE('CAD$,T,Ha'[Sourcing Area], MAX('CAD$,T,Ha'[Sourcing Area])) & 
    " in " & 
    MAX('CAD$,T,Ha'[Growing Season])
)

I have bookmark page, “Sourcing area pie chart”, that has pie charts for all sourcing areas in our system. All the pie charts are filtered per sourcing area under “Filters” for the visuals. I have a measure that is dynamically adjusted.

For example if we have a pie chart filtered for sourcing area Y,

The user selects growing season X and there is data for Y in growing season X, then the title should show,

“Input cost % for Y in X” – case A

and in the case that there is no data for Y in growing season X it should show,

“No data available for Y” – case B

However, currently the measure only works with case A, and case B not. The issue seems to stem from if there is data for a sourcing area for a specific growing season. If there is, the measure works as intended, if there isn’t it does not work.

I am not sure what the issue is and how to fix it. I have made sure the slicer for sourcing is not affecting the pie chart, but the issue persists.

Measure used:

_SourcingareaPietitle =

IF(
    ISBLANK(MAX('CAD$,T,Ha'[Growing Season])) || 
    ISBLANK(SELECTEDVALUE('CAD$,T,Ha'[Delivery period])) || 
    ISBLANK(SELECTEDVALUE('CAD$,T,Ha'[DataType])), 
    "No data available for " & 
    SELECTEDVALUE('CAD$,T,Ha'[Sourcing Area], MAX('CAD$,T,Ha'[Sourcing Area])), 
    "Input cost % for " & 
    SELECTEDVALUE('CAD$,T,Ha'[Sourcing Area], MAX('CAD$,T,Ha'[Sourcing Area])) & 
    " in " & 
    MAX('CAD$,T,Ha'[Growing Season])
)

• powerbi
• dax
• pie-chart
• title
• measure

1 Answer 1

I think you have a problem with the filtering context and how ISBLANK interacts with your model specifically, if no rows exist in the table for the given filtering combination, the measure may not evaluate as expected so you may try the below :

_SourcingareaPietitle = 
IF(
    ISBLANK(
        CALCULATE(
            MAX('CAD$,T,Ha'[Growing Season]),
            REMOVEFILTERS('CAD$,T,Ha')
        )
    ),
    "No data available for " & 
    SELECTEDVALUE('CAD$,T,Ha'[Sourcing Area], MAX('CAD$,T,Ha'[Sourcing Area])),
    "Input cost % for " & 
    SELECTEDVALUE('CAD$,T,Ha'[Sourcing Area], MAX('CAD$,T,Ha'[Sourcing Area])) & 
    " in " & 
    MAX('CAD$,T,Ha'[Growing Season])
)