Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Dynamic filtering on Power BI

How can I make a dynamic filter on a Power BI chart?   I have a MONTH table and it contains these values: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12. I dot not want to display data for months that are b...
Need Help
Show and Tell
  • Bitwize_PowerBI's avatar
    Bitwize_PowerBI
    9 years ago

    Hi,

     

    You have to create a measure like this:

     

    Measure = calculate(sum('table'[data]); 'monthtable'[month] <= month(today()))

    and use this measure in your chart.

     

  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    Anonymous

     

    You can't apply expression in visual level filter. I suggest you create a calculated table which always filter records for months greater than current month.

     

    Table=FILTER(Table,Table[Month]>MONTH(TODAY()))

    Regards,

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thank you, both solutions worked!