Forum Discussion
Helper IIHow to hide line chart
I build this line charts to show total for prev and current FY. How do i hide the future months (yellow one)
Hi, It looks your 'TotalProvApproved_FY25_26' likely a explicit measure you created for the current fiscal year FY25_26. the other one 'Sum of Prov_Approved_FY24_25' an implicit measure that Power BI automatically summed a numeric column for the previous fiscal year FY24_25.
If you have a proper Date table and you are using this Date table to filter your Fact table then try adjusting your '[TotalProvApproved_FY25_26]' to
IF (
'Date'[Date] <= TODAY(),
[TotalProvApproved_FY25_26],
BLANK()
)
7 Replies
- Selva-Salimi
Solution Sage
Hi Marshmallow ,
the easiest solution is to use an if function, like if([value]=0, blank())
If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.
- MasonMA
Super User
Hi, It looks your 'TotalProvApproved_FY25_26' likely a explicit measure you created for the current fiscal year FY25_26. the other one 'Sum of Prov_Approved_FY24_25' an implicit measure that Power BI automatically summed a numeric column for the previous fiscal year FY24_25.
If you have a proper Date table and you are using this Date table to filter your Fact table then try adjusting your '[TotalProvApproved_FY25_26]' to
IF (
'Date'[Date] <= TODAY(),
[TotalProvApproved_FY25_26],
BLANK()
) - Royel
Hi Marshmallow you can easily achieve this by using a if condition
IF ( 'Date'[Date] <= TODAY(), [MeasureName], BLANK() )Note: You need to update this measure based on your information.
Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!
- danextian
Hi Marshmallow
It seems you’re using an implicit measure for Approved FY24_25, where future months are showing as 0. I’d suggest going into the query editor and replacing those zeros with null values.
v-hashadapuCommunity Support
Hi Marshmallow , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.
- v-hashadapu
Hi Marshmallow , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.
- v-hashadapu
Hi Marshmallow , Hope you're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.
