Forum Discussion
Dynamically Hiding Future Values in Bar Chart
Hello,
I am needing some help with the bar chart below. I am wanting to only show values for the Actuals (orange bar) for the month we are reporting on. For example, I refreshed the report today and need to see ONLY January values. The chart is currently pulling in January and February. The refresh date will always be 1 month ahead of what I'm reporting on.
I'd like to build a formula that looks at today's date and automatically pulls in the prior months. So in July for example, I'm only looking at January - June for Actual amounts.
The Budget values (yellow bar) and Prior Year Actual values (blue line) should be shown as is, nothing needs to change there.
Y-Axis = 'CalendarTable'[Date]
X-Axis = Sum of 'vCorporateGandA'[Amount]
Column Ledgend = 'vCorporateGandA'[LedgerType]
I ran the testing as follows. Maybe it'll help you.
My sample:
Create a measure as follows
Measure = IF( DATEDIFF(SELECTEDVALUE('Table'[Date]), TODAY(), MONTH) >= 0 && DATEDIFF( SELECTEDVALUE('Table'[Date]), TODAY(), MONTH) <= 6, 1, 0)Put the measure into the visual-level filters, set up show items when the value is 1.
Is this the result you expect?
If I've misunderstood you, please provide detailed sample data and the results you are hoping for: How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account. We can better understand the problem and help you.
Best Regards,
Community Support Team _YuliaxIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
ok, what have you tried and where are you stuck?
I ran the testing as follows. Maybe it'll help you.
My sample:
Create a measure as follows
Measure = IF( DATEDIFF(SELECTEDVALUE('Table'[Date]), TODAY(), MONTH) >= 0 && DATEDIFF( SELECTEDVALUE('Table'[Date]), TODAY(), MONTH) <= 6, 1, 0)Put the measure into the visual-level filters, set up show items when the value is 1.
Is this the result you expect?
If I've misunderstood you, please provide detailed sample data and the results you are hoping for: How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account. We can better understand the problem and help you.
Best Regards,
Community Support Team _YuliaxIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
