Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
I have problem with Bar Chart showing value for end date of year (as it should be) but I want it to show specific date value.
Years prior show value for last day of the year but current value does not exist for now. I mean I excluded it with my DAX:
Final =
IF (
MAX ( 'Calendar'[Date] ) <= EDATE ( EOMONTH ( TODAY (); 0 ); -1 );
[Measure];
BLANK()
)
This is suppose to insert blank if we are not greater or the last day of current month.
!In this picture there is 0 not blank, so the December row is visible!
So I have two options and I think one is not possible:
1) Make bar chart show November value for only 2019 (I think this is not possible)
2) Repeat November value in December without any influence of values already existing in December.
My measure Final is quite complicated and I cannot change it much.
Is this somehow possible?
Thanks.
K.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
10 | |
10 | |
10 | |
10 |
User | Count |
---|---|
19 | |
14 | |
13 | |
11 | |
8 |