Forum Discussion

lotus22's avatar
lotus22
Icon for Helper III rankHelper III
4 years ago
Solved

Remove Duplicate Weeks from Bar Axis

I have duplicate Week 13 on the axix because there are two dates in the field. I am using formula to get week number from the date. I get daily data for current week (13) and weekly data for previous...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, lotus22 

    What is your raw data like? What bar visual are you using?

    You can consider creating an identity column and apply it to visual filter pane to filter data.
    Caculated column:

    flag =
VAR r1 =
    CALCULATE ( MAX ( 'Table'[Date] ), ALLEXCEPT ( 'Table', 'Table'[WK Ending] ) )
RETURN
    IF ( 'Table'[Date] = r1, 1, 0 )

     

    Best Regards,
    Community Support Team _ Eason

     

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, lotus22 

What is your raw data like? What bar visual are you using?

You can consider creating an identity column and apply it to visual filter pane to filter data.
Caculated column:

flag =
VAR r1 =
    CALCULATE ( MAX ( 'Table'[Date] ), ALLEXCEPT ( 'Table', 'Table'[WK Ending] ) )
RETURN
    IF ( 'Table'[Date] = r1, 1, 0 )

 

Best Regards,
Community Support Team _ Eason