cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stevenls
Helper III
Helper III

Static totals line on a bar chart visualisation

Hi there,

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.

 

Thank you.

 

1 ACCEPTED SOLUTION

You can use MAX LINE OR MIN LINE from Visualization pane >> Analytics!

View solution in original post

8 REPLIES 8
hp_2198
Helper I
Helper I

 

 

Hello, I just used Line and Cluster column chart from the Visualization pane. 

dataset.png

 

Graph.png

 

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.

Please provide more information related to columns and measures of your model.

 

This measure just calculates the total for the hardware items.  I then filter it for 'Unallocated'

ReportingFieldCount = CALCULATE(COUNT('Ch_Computer_Config'[HCReportingField]))
The other table 'tblNewStarters' has a count based off the transform which for a given week is the sum of the hardware items needed, which aligns with what I referred to above.
 

You can use MAX LINE OR MIN LINE from Visualization pane >> Analytics!

View solution in original post

so do the bar chart based on the new starter information and use the max in the analytics from the measure?

Yes, try that way once!

amitchandak
Super User IV
Super User IV

@stevenls , We need to know the dimension and measure for that .

Assume for item dimension fact allocation show allocation 

 

then

sumx(values(Item[Item]), if(isblank(countrows(allocation)) , 1, blank())

 

Bascially converting blank means no record to 1 and record to null



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors