Forum Discussion

TBStacey's avatar
TBStacey
Helper I
2 years ago
Solved

Stacked bar graph question

I'm trying to create a bar graph that shows the "Earliest Confirmed Date" of a test on the X axis and the number of properties (PIN) confirmed via that test on the Y axis.   Since more than one tes...
  • lbendlin's avatar
    lbendlin
    2 years ago

    The first part is simple - you can use the implicit measures

     

     

    For the second part ( the chart ) you need a couple of things - for a proper implementation  you need a calendar table for the X axis, and then a measure for the mapping.  Or you can cheat and create a calculated table that materializes the prior result. This can be done by "borrowing"  the DAX code from the visual

     

    and cleaning it up as

    Table2 = SUMMARIZECOLUMNS(
    			'Table'[PIN],
    			'Table'[animal_state],
    			"MinConfirmed_Date", CALCULATE(MIN('Table'[Confirmed Date]))
    		)

     

    Then you can render your column chart.

    or in categorical axis

     

    see attached