I have looked around different place and asked a couple of quesitons but can't seem to lock down if this is possible or not.
I have a visualisation which shows on a weekly basis the total number of hardware resources needed for our new artists starting.
Using 1 item as an example - Spec A96R (a workstation)
For the bar chart side of this there would be weekly bars to show the total needed for our onboarders.
17 May - 8
24 May - 6
31 May - 11
I also pull in our CMDB information and derive counts of our hardware (allocated / unallocated).
What I would like to show on the visualisation is a horizontal line that shows at the current point in time the unallocated count for the hardware.
In this example as of now there are 27 Spec A96R unallocated, so there would be vertical bars of the various weeks need for the machines and horizontal lines from the CMDB that shows the same hardware just as their unallocated total.
Is there a way to achieve this in a visualisation.
Solved! Go to Solution.
yeh I tried that but the issue is the CMDB doesn't have a date as such. The measure I have just displays the total per Hardware Description that = unallocated. There is only ever 1 number per hardware item at any given time as it is a total.
This measure just calculates the total for the hardware items. I then filter it for 'Unallocated'
@stevenls , We need to know the dimension and measure for that .
Assume for item dimension fact allocation show allocation
sumx(values(Item[Item]), if(isblank(countrows(allocation)) , 1, blank())
Bascially converting blank means no record to 1 and record to null
Check out the News & Announcements to learn more.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
Mark your calendars and join us for our next Power BI Dev Camp!
Check out our new Discover Your Career Path blog post series and get all the details.