Create a chart per week

Question

Hello All,&nbsp;I am trying to create a chart for per week analysis. The source is excel file that contains the list of assets, asset status, Begin Date and End Date. The chart should tell the user the number of assets that are in particular status(active/inactive) in the user selected week. My problem is - if there is an asset that is in a status for more than one week, how should I show it in the chart for week over?]\&nbsp;Thanks in Advance!

greg_deckler · Answer

First,&nbsp;Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
&nbsp;
That being said, I have created a couple of Quick Measures to deal with things like what you are talking about:
&nbsp;
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

v-cherch-msft · Answer

Hi&nbsp;shraddha_psingh&nbsp;You may try to add a measure and drag the measure to Visual Level Filters to show the value as requested. For example:Measure =
IF (
    DATEDIFF ( MAX ( Table[begin date] ), MAX ( Table[end date] ), DAY ) &gt; 7,
    "Over Week"
)&nbsp;Regards,Cherie

shraddha_psingh · Answer

Hi Greg,&nbsp;Thank you for your reply! Apologies.. this is my first question to the forum.&nbsp;&nbsp;While using quick measure as suggested by you for open tickets, it got an error for [Date] as shown below -&nbsp;&nbsp;&nbsp;I created a new table for Dates using CalendarAuto() and created the releationship but no success. Is there anything I am missing?https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364&nbsp;

Forum Discussion

Create a chart per week

3 Replies

Related content

Creating a Control Chart

Creating a Sankey Chart in Power BI

Need help creating week number

Create Previous Week Filter?

Creating Index base 100 charts