How to create monthly and daily option for the slicer for the dataset

[Anonymous]

Hi, 

I tried to create but finding errors during the process.

I just want to have monthly and daily view in the slicer option and change the bar chart value accordingly.

I have provided the sample pbix file here:
https://drive.google.com/file/d/10qcIzZVvGWvBe0YtONw_wXdFMkgw2lTl/view?usp=sharing

I need something similar to this:

Please kindly let me know of the solution, It will be a great support, as I'm very new to Power BI.

[Anonymous · Accepted solution]

Hi @Anonymous ,

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) We can create calculated columns.

Month = MONTH('TotalEnergy'[LocalSystemDate])

Day = DAY('TotalEnergy'[LocalSystemDate])Day = DAY('TotalEnergy'[LocalSystemDate])

(3) Create a field parameter and then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Anonymous]

Thank you @Anonymous  I wanted this solution.

[amitchandak]

@Anonymous , One way is to create measures and use a field parameter. You can rename the name is field parameters

If you need with date selection use independent date table in slicer

12 month trend

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -12) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

or

30 Day trend

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min =  _max - 30
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

If you not selecting date from slicer

this can work

new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = eomonth(_max, -12) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

another way

https://medium.com/chandakamit/power-bi-when-i-felt-lazy-and-i-needed-too-many-measures-ed8de20d9f79

[Anonymous]

Hi @amitchandak 

Thank you very much for the support.

Just wanted to know, If you have already tried this with the pbix file I shared, Could you reshare it with me please. It will be easier for me.