March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello everyone. I'm hoping someone can help a bit of a Power BI novice here.
I'm trying to build a visual using a Line and Clustered Column chart. The chart should contain the last 6 full calendar months' downtime as one data point and availability % as the other data point, using the incident end date on the x-axis for the date range. The issue I am having is that when I plot the downtime on the chart, it works - just shows the last 6 calendar months' data. When I add the availability %, though, the date range extends to the beginning of 2022 and through to the end of 2024. I've tried using filters, but the availability % doesn't seem to adjust.
I can get around the situation temporarily this month by adding a filter which excludes entries where downtime = 0, but this would then not show entries on the visual where we genuinely haven't had any downtime.
For a little more information....
Visual with just downtime
Visual with downtime and % availability
Any help would be massively appreciated, and please let me know if I need to include some additional information.
Thanks
David
Solved! Go to Solution.
Thanks again . I played around with your suggestion and eventually came up with the following:
Its not the perfect solution as it only works on a report looking at the past 6 months, but it will do for now until we can come up with something more flexible.
Thanks again @_AAndrade . That fixes the December issue, but re-introduces the other dates into the visual
Thnaks
David
Probably to do what you want, you need to see the min and max date of the x-axis that has value and after apply the measure.
For example:
VAR _MinDate = CALCULATE(MIN(Date), [measure] <>0)
VAR _MaxDate = CALCULATE(MIN(Date), [measure] <>0)
RETURN
IF(
Selectvalue(Date) >= _MinDate && Selectvalue(Date)<= MaxDate,
[measure],
Blank()
)
Probably the measure that I wrote need to fix some issues but the idea is this.
Proud to be a Super User!
Thanks again . I played around with your suggestion and eventually came up with the following:
Its not the perfect solution as it only works on a report looking at the past 6 months, but it will do for now until we can come up with something more flexible.
You just need to dynamically configure the _Min and _Max variables according to your model. That's why I used calculate.
Proud to be a Super User!
I think the problem is on "% Availability" measure. Put some IF function that only do the "% Availability" if Downtime has value.
Something like this:
IF(NOT(ISBLANK( [Downtime])), 1-SUM(Issues[Impact on Uptime (%)], BLANK())
Proud to be a Super User!
Thanks @_AAndrade . That has almost solved it. Definitely a step forward. The issue I am left with now is where there is no downtime in a given month, that month is not presented in the visual, whereas I would like it to just show as being blank. As you can see in the attached - December is not presented on the visual
Thanks,
David
Replace BLANK() to 0 (zero). I think it could solve the problem
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |