Forum Discussion

pauldago's avatar
pauldago
Regular Visitor
9 years ago
Solved

Clustered column chart

Hi guys, I need to have your help to solve my issue with Clustered column chart in Power BI. I have an ITEMS list in Excel with the CREATION date and the STATUS date. I'd like to create a Clustered c...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi pauldago,

     

    You count them by different columns and different date. So a date table is essential. First we create a new date table which will be our x-axis. Then create two measures.

    1. Create a date table (image 1).

    Date =
    CALENDAR ( "2001-01-01", "2017-12-31" )

     

    2. Create two measures 

    Deleted =
    CALCULATE (
        COUNTROWS (
            FILTER ( 'Table', 'Table'[STATUS DATE].[Year] = MIN ( 'Date'[Date].[Year] ) )
        ),
        'Table'[STATUS] = "deleted"
    )

     

     

    Created =
    COUNTROWS (
        FILTER ( 'Table', 'Table'[CREATION DATE].[Year] = MIN ( 'Date'[Date].[Year] ) )
    )

     

     

     

     

     

pauldago's avatar
pauldago
Regular Visitor
9 years ago

Hi smoupre, thanks a lot for your help. I can use your suggestion for the DELETED Items as I have it as a Status, but I don't have the information CREATED as a Status. I have only the Creation Date column. 

Thank you

EminUZUN's avatar
EminUZUN
Frequent Visitor
9 years ago

Do you have status column for all but empty?
If so, you may use <> (does not equal to)

CREATED= CALCULATE(COUNTROWS(Table),[STATUS]<>"DELETED")