Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Bar Chart show data from current date each month

Hello everyone, I need guidance for what I currently thinking, is it possible to create a Bar Chart that will show data from certain dates or filtered dates in each month? Well, let's say I want t...
Need Help
Show and Tell
Tips and Tricks
  • TheoC's avatar
    TheoC
    4 years ago

    Hi Anonymous 

     

    If I am understanding your requirement, you should be able to take the "Day" from the Date Hierarchy and add that as a Slicer so that you can select the Day of each Month and compare only the Day that you want (i.e. first, second, third, fourth, etc., etc)...

     

     

    Hope this helps 🙂

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Create a measure like

 

=
var _max = maxx(allselected('Date'), 'Date'[Date])
var _min = maxx(allselected('Date'), 'Date'[Date])
return
calculate(sum(Table[Value]), filter('date', 'Date'[Date] >=_min && 'Date'[Date] <=_max && 'Date'[Date] = eomonth(min('Date'[Date]),-1)+1 ))

 

or

 

=
var _max = maxx(allselected('Date'), 'Date'[Date])
var _min = maxx(allselected('Date'), 'Date'[Date])
return
calculate(sum(Table[Value]), filter('date', 'Date'[Date] = eomonth(min('Date'[Date]),-1)+1 ))

 

or

 

calculate(firstnonblankvalue'Date'[Date], sum(Table[Value]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi amitchandak, thank you for your reply.

    I try your 1st formula, but when I put that to the Bar Chart, everything goes blank. Same with the 3rd formula.
    I try the 2nd formula, which only shows 1 date data only and I can't change it to other dates by using a filter.