Forum Discussion

julesdude's avatar
julesdude
Icon for Post Partisan rankPost Partisan
3 years ago

Bar Chart Measure Needed to Count Total Dates Beyond a Set Date

Hi, I'm having some difficulty getting some DAX to work in favour of a bar chart I have in my report. Here is a watered down version of the table in my data model that the bar chart references: ...
Need Help
ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
3 years ago

But that depends on the date you choose...

 

julesdude's avatar
julesdude
Icon for Post Partisan rankPost Partisan
3 years ago

ERD 

It does. But I've got dates in the "New Option Effective Date" column up to October 2031. They should be being counted and shown as their Option Effective Date ID is 4. Instead, if I select in the slicer a date, say, 13/07/2027, I just get a blank graph.