Gantt Chart with Multiple Tasks on a Single Row
Hi all - Looking for a visual in a Gantt-style chart. My needs revolve around staffing - I have employees that work on reviewing products, broken up by category. There are multiple reviews happening on staggered timelines year-round, with busy durations and calm durations. I am trying to see all reviews in a gantt view with the durations of craziness and calm identified on one row, all against each other, so I can strategically assign my employees so that the busy durations do not overlap. I am having trouble having multiple start/end dates appear on one row. If I have Task 1 starting in January and ending in March, and I would like to format that time frame as "red" for busy and then immediately following, Task 2 which begins when Task 1 ends and goes through April as "green" formatting to indicate calm. Any recommendations on how to use multiple start/end dates on the same row, so that I can keep dates on the X Axis? I'm being forced to either pick one task or use durations only, and neither are useful without the other. This is my end goal: Thank you!
Area graph -Power BI 101
What do I need to do in Power BI to show this table as an area graph with an X axis of date and Y axis of value, with each of the categories stacked in value. I want to be able to show total and drill down into each category if necessary. Darrin Category 01-Jan-22 01-Feb-22 ######## 01-Apr-22 01-May-22 01-Jun-22 01-Jul-22 01-Aug-22 01-Sep-22 01-Oct-22 01-Nov-22 01-Dec-22 01-Jan-23 01-Feb-23 01-Mar-23 01-Apr-23 01-May-23 Cat 1 £500,000 £569,722 £81,776 £113,583 £115,506 £153,297 £153,297 £170,743 £242,794 £230,740 £198,933 £198,933 £181,487 £111,765 £111,765 £111,765 £1,923 Cat 2 £0 £0 £0 £381,738 £524,656 £224,656 £224,656 £189,151 £189,151 £81,738 £81,738 £81,738 £0 £0 £0 £0 £0 Cat 3 £0 £0 £0 £0 £0 £103,691 £103,691 £103,691 £103,691 £103,691 £103,691 £103,691 £103,691 £0 £0 £0 £0Use of timeline across a number of different reports
Hi All, Power BI newbie here, desperately trying to get a report I created to work alongside a timeline. i think the issue is that one report has the date (which I've used for the timeline) and the other also does, but I can't use 2 timelines. I did add in a start date, end date and week number relationship which the sheet is linked to, but it doesn't like it. Any suggestions....before I hit the wine. thanks RachelTimeline Storyteller custom visual not working
Hi, I'm not sure exactly where to post this but I'm sure someone will correct me if necessary 🙂 I'm not sure if it's been reported here previously (doesn't seem to be) but the Timeline Storyteller custom visual for Power BI appears to have broken with a recent PBI update.. there is a growing list of complaint feedback on the MS AppSource page (link below), but it appears the developer (which says it's Microsoft) hasn't acknowledged this so far? The negative reviews seems to begin around the end of last month (July 2020). https://appsource.microsoft.com/en-au/product/power-bi-visuals/WA104381136?tab=Reviews# Just trying to find a way to bring this to someone's attention if possible, as obviously people are trying to use it (including myself) with no luck. Hoping some action can be taken. Cheers, GregCreate a timeline view using the Stacked Bar Chart Visualiztion
Hopefully there's a Datanaut out there that can help. I can, and have, for years been able to create time line views in Excel Charts using a Bar chart like so: In Power BI, I have an ask to create a view just like this. Our organzational security FORBIDS the use of 3rd party custom visuals so that is not a solution. This is the closest I have been able to come: I am so close I can taste it, but cannot figure a way to first, make the axis values convert from the numeric format into date format, and then second, set it so these are monthly values, not every 50 days. Anyone that wants a big Kudos from me that has a solution to this one, let me know! Warmest Thanks in advanceDAX relative time function to count number of instances between specific times
Hi, I have some data in the following format: Incident Number Date Occurred Incident Name 143 1/1/2001 12:00 ex 1 361 1/2/2001 14:00 ex 2 I am trying to count the number of incidents that have a [Date Occurred] within a certain time frame relative to the current date. I want the number of incidents with a [Date Occurred] between 7 days ago after 12:00 PM to today before 12:00 PM. To give an example: if it is Thursday today, I would like to count the number of incidents with a [Date Occurred] between LAST thursday after 12:00 PM and 12:00 PM this Thursday (today). Ideally, I would like a measure to get this count. Thanks!
