Forum Discussion

shraddha_psingh's avatar
shraddha_psingh
New Member
8 years ago

Create a chart per week

Hello All,   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 th...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi shraddha_psingh

 

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 ) > 7,
    "Over Week"
)

 

Regards,

Cherie