Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Disable Table show no data rows

Hi everyone,

 

I am creating a table with Sales vs Forecast by Region.  The Region is a filter. My question is when I select a Region, all subregion rows are shown although Sales is blank. All subregion has forecast data. For example, my dashboard metric as follows:

SubregionSalesForecast
SF1012
LA1314
NYC 14

 

When I select California, NYC is shows as well. I only wanna see the related subregions are shown in metric. Is there any way to solve this problem? Thanks. 

Need Help

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      It is an example. Assume NYC region is NY. When I select NY, the CA cities are shown either. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi, try this:

     

    Create this calculated column:

    IncludeExclude = IF(Your_Table[Sales] == BLANK(), "Exclude", "Include")
     
    Click on your table, open the Filter pane. Drag in the box "Filters on this visual" the new column created (IncludeExclude) and flag "Include"
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for your response. I tried, but not works. The sales in the raw data is no blank. I'd like to no sales data in dashboard is shown. 

      • VasTg's avatar
        VasTg
        Memorable Member
        6 years ago

        Anonymous 

         

        Is region and Subregion from same table? if not, do  you have relationship defined between those tables?