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 created a simple data model in order to ilustrate what I want to accomplish.
My goal is to create a bar chart (that will be filtered by a slicer) that shows months in the X axis and the sum of the value column from the fact table.
Since we are currently on June, but the are no instances in the fact table for that month, a simple measure SUM(FactTable[Value]) will return blank for June. Using COALESCE(SUM(FactTable[Value]), 0) will display June, but also all the other months that are not the current one.
How can I return 0 in the visual for the current month while not showing months past the current?
Solved! Go to Solution.
Hello @flavioaas ,
If I understand correctly, you want to show case the current month even if it was blank within the bar chart.
Hello @flavioaas ,
If I understand correctly, you want to show case the current month even if it was blank within the bar chart.
User | Count |
---|---|
17 | |
14 | |
13 | |
13 | |
12 |
User | Count |
---|---|
19 | |
15 | |
14 | |
10 | |
9 |