Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic value frequency based on date - is it possible?

I've been working on this for a couple of days now and I'm at the point where I need a reality check.   I want to be able to create a chart that shows the frequency of a column value within a selec...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    4 years ago

    Anonymous  This can work, but you'll get 1 for every date with your sample data. Do you have a DimDate table?

    https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html 

     

    You could put for example Month in the Axis, Color in the Legend, and then create a measure:

     

    Frequency of Color = COUNT( Table[Color] ) 

     

    and put that in Values to display the frequency on the Y axis.

     

    Then use your date slicer to change the date range. 

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous  This can work, but you'll get 1 for every date with your sample data. Do you have a DimDate table?

https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html 

 

You could put for example Month in the Axis, Color in the Legend, and then create a measure:

 

Frequency of Color = COUNT( Table[Color] ) 

 

and put that in Values to display the frequency on the Y axis.

 

Then use your date slicer to change the date range.