Forum Discussion

vanessafvg's avatar
vanessafvg
Community Champion
7 years ago
Solved

Ignore filter on page

Hi have filter that selects the last reported date for all objects on a page.   However i want to see the all reported dates for a certain column (not measure)

 

the column is called rag status, i havent' worked on power bi for a few months and im totally baffled, i think ive forgotten how to do this.

 

for the life of me filter, all, ?  argh.

 

essentially i want to display on a ribbon chart all reporting dates with the rag status and to ignore the page filter of latest reporting date.

 

help!

 

tia

  • vanessafvg's avatar
    vanessafvg
    7 years ago

    hi 

    v-danhe-msft

    no that didn't solve the problem what did though was me adjusting the edit interactions i just set it to not filter on that visual

3 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee

    Hi vanessafvg,

    Where do you want to show the data? If you want to show the data in the card, you could use dax with ALL function to show the data you want:

    But if you want to show in other visualization, I am afraid you could just get the filtered value. If you want to see all the data, you could just delete the fileter:

     

    Regards,

    Daniel He 

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee

    Hi vanessafvg,

    Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

     

    Regards,

    Daniel He

    • vanessafvg's avatar
      vanessafvg
      Community Champion

      hi 

      v-danhe-msft

      no that didn't solve the problem what did though was me adjusting the edit interactions i just set it to not filter on that visual