Forum Discussion
Helper IIFilter X-axis without filtering Data
Community SupportHI Kurtle
What is "when I filter my chart to be from Jan 1, 2020 onwards I am losing some costs." ?
maybe you could adjust the measure as below:
Field Expenses =
CALCULATE (
SUM ( 'Line Items'[Amount] ),
FILTER ( 'Line Items', 'Line Items'[Major Account] = "999" )
)
If not your case, please share your sample pbix file and your expected output.
Regards,
Lin
Helper IIv-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
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/38490Regards,
Lin