Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Date X Axis

Good Morning!   I've been struggling to figure out how to get an X-Axis for dates set up for reporting and was looking for help trying to create reports using a proper X-Axis for dates.   One of ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous ,

     

    Please refer to below measures.

    count Test1 =
CALCULATE (
    COUNT ( 'Sample Data'[Test1] ),
    FILTER (
        ALLSELECTED ( 'Sample Data' ),
        'Sample Data'[Test1].[Date] >= MIN ( 'Date'[Date] )
            && 'Sample Data'[Test1] <= MAX ( 'Date'[Date] )
            && 'Sample Data'[Test1].[Year] = SELECTEDVALUE ( 'Date'[Date].[Year] )
            && 'Sample Data'[Test1].[Month] = SELECTEDVALUE ( 'Date'[Date].[Month] )
    )
)

count Test2 =
CALCULATE (
    COUNT ( 'Sample Data'[Test2] ),
    FILTER (
        ALLSELECTED ( 'Sample Data' ),
        'Sample Data'[Test2] >= MIN ( 'Date'[Date] )
            && 'Sample Data'[Test2] <= MAX ( 'Date'[Date] )
            && 'Sample Data'[Test2].[Year] = SELECTEDVALUE ( 'Date'[Date].[Year] )
            && 'Sample Data'[Test2].[Month] = SELECTEDVALUE ( 'Date'[Date].[Month] )
    )
)

    I have uploaded the .pbix file.

     

    Best regards,

    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Hi @v-yulgu-msft ,

 

Were you able to access th file?

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous ,

 

Please refer to below measures.

count Test1 =
CALCULATE (
    COUNT ( 'Sample Data'[Test1] ),
    FILTER (
        ALLSELECTED ( 'Sample Data' ),
        'Sample Data'[Test1].[Date] >= MIN ( 'Date'[Date] )
            && 'Sample Data'[Test1] <= MAX ( 'Date'[Date] )
            && 'Sample Data'[Test1].[Year] = SELECTEDVALUE ( 'Date'[Date].[Year] )
            && 'Sample Data'[Test1].[Month] = SELECTEDVALUE ( 'Date'[Date].[Month] )
    )
)

count Test2 =
CALCULATE (
    COUNT ( 'Sample Data'[Test2] ),
    FILTER (
        ALLSELECTED ( 'Sample Data' ),
        'Sample Data'[Test2] >= MIN ( 'Date'[Date] )
            && 'Sample Data'[Test2] <= MAX ( 'Date'[Date] )
            && 'Sample Data'[Test2].[Year] = SELECTEDVALUE ( 'Date'[Date].[Year] )
            && 'Sample Data'[Test2].[Month] = SELECTEDVALUE ( 'Date'[Date].[Month] )
    )
)

I have uploaded the .pbix file.

 

Best regards,

Yuliana Gu