Forum Discussion

Kurtle's avatar
Kurtle
Helper II
6 years ago

Filter X-axis without filtering Data

Hi Friends,    I am currently working with an accounting model that contains 2 date tables. One for the accounting date and one for the activity date. I am trying to filter the data down based on t...
Need Help
Kurtle's avatar
Kurtle
Helper II
6 years ago

v-lili6-msft Oops. I should have clarified that. When I filter my activity dates down to be from Jan 1, 2020, onwards so that my bar chart only shows those bars  I lose some costs because there are 2 date columns in me Line Items Table which is getting filtered out during that process.

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  Kurtle 

You are using different column to filter and display data in the visual.

you filter the data down based on the accounting date but displaying it on activity date. 

This is a normal result, what your expected output? could you please share your sample pbix file and your expected output.

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Regards,

Lin