Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dynamic Filtering at PowerBI Report level

I have a report with 4 visualizations and a few cards that is currently displaying all of the data. I'd like to filter the data (and thus the visualizations) using some logic that uses the slicer val...
  • v-jiascu-msft's avatar
    8 years ago

    Hi Anonymous,

     

    Just see from your data here, it could be easy with a calculated column. You can check out the demo in the attachment. Can you share sample please?

    Column =
    IF ( ISBLANK ( [ReportDate] ), [FiscalYear], YEAR ( [ReportDate] ) )
    

    Dynamic_Filtering_at_Power_BI_Report_level

     

    Best Regards,

    Dale