Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi dear Community, I need your help:
I have a chart where the X axis are days... My problem is that for example the day 21 doesnt appear because there is no data but I still have the budget of the day 21 ...How can I make the day 21 to appear as 0 and the budget.
(Im using a calendar table which have all dates and try with the calendar and with the column date of my fact table a nothing... and in the pic number two as you see Im using scale type linear which is the only option available in the menu)
Any help would be so much appreciate.
Solved! Go to Solution.
the issue is with the TERRITORIAL field - if you remove it from column totals you can see the budgets properly
the model is quite complex, so I cannot really figure out why it's acting like this - have you thought about simplyfying it a bit?
can you share sample data?
Hi @Stachu!!! that would be awesome and easier but is too big and confidential data :(....is there another way for you to check something and help me out?
@christianfcbmx without the data I can only give general advice - you can post here anonymised small sample, confidentiality applies to all of us 😉
the general tip - you should have a calendar dimension joined with your actual and budget tables, if you use it in the axis then the budget will appear properly, as long as it's assigned to 21st
the issue is with the TERRITORIAL field - if you remove it from column totals you can see the budgets properly
the model is quite complex, so I cannot really figure out why it's acting like this - have you thought about simplyfying it a bit?
Hi All - thought I'd post my issue as it seems similar:
I need to display the date from today until 52 days from now - even if the data is blank at day 52 etc.
However the x-axis stops at day 45 (may 2) as shown below due to null values...
The workaround Is to put a line in for "day#" and then make the line invisible......but surely there is a way i can do this better??
thanks in advance!
can you send a pbix sample file?
Hi - i cant share this data unfortunately.....i tried to remove everything that was confidential and then it just became a mess. **bleep** - if you have any suggestions as to a solution please let me know...thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |