Forum Discussion

Dev-13's avatar
Dev-13
Icon for Helper I rankHelper I
4 years ago
Solved

Drill Down with Custom Message

Hi I have a drill down chart. The x axis has 2 categories - Category and Sub Category.   3 of the Categories do not have a sub category, and the chart is blank when you right click to drill down. ...
DAX
Drilldown help
  • Adescrit's avatar
    Adescrit
    4 years ago

    Hi Dev-13 ,

     

    How about this:

     

     

    No data = if(SELECTEDVALUE([SubCategory]) = BLANK(),"No data available","")

     

    So you just need to add the same [SubCategory] field to the measure that is being used in your visuals.

     

     

Adescrit's avatar
Adescrit
Icon for Impactful Individual rankImpactful Individual
4 years ago

Hi Dev-13 ,

 

How about this:

 

 

No data = if(SELECTEDVALUE([SubCategory]) = BLANK(),"No data available","")

 

So you just need to add the same [SubCategory] field to the measure that is being used in your visuals.