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 guys,
i have a revenue bar chart per day. On some days i don't have revenues but i still want to show the date data points:
For the 15. Apr it's fine but the dates go up until the 25.04.2020. How can i blend them in aswell?
Thank you!
Hi, @Anonymous
Based on your description, I created data to reproduce your scenario.
Table:
You may create a measure as below.
Revenue Measure =
IF(
ISBLANK(SUM('Table'[Revenue])),
0,
SUM('Table'[Revenue])
)
Result:
You may also try to click 'Visualizations'=>'Format'=>'X axis' and set as below.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks! Works perfectly
Hi @Anonymous
for this purpose you need to create a calendar table like
Calendar = CALENDARAUTO()
the create relationships between Calendar and your fact table by Date field, then put Calendar[Date] field to visual as X-axis
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |