Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Chart ignore page filter

Hi,

 

i have a measure 'Calc activation ignore date', it ignores the page filter selected and select the whole month.

But the chart did not show each date like the one i want below, it only show the 'Date selected with the sum of whole month.

I want the chart to show everyday 'calc activation', can a kind soul please assist ?

 

Thanks

 

 

Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anonymous ,

    Unfortunately, power bi does not support use measure formula to expand the axis category records.

    For your requirement, I'd like to suggest you change the direction and mode from current table to calendar table to ignore the filter effect from calendar to current table.

    What is the Direction of Relationship in Power BI? 

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Anonymous ,

    Unfortunately, power bi does not support use measure formula to expand the axis category records.

    For your requirement, I'd like to suggest you change the direction and mode from current table to calendar table to ignore the filter effect from calendar to current table.

    What is the Direction of Relationship in Power BI? 

    Regards,

    Xiaoxin Sheng