To switch between months

[harshagraj]

Hi all, Please help me to the achieve the below. I have to use slicer(Report Date). I have measures as Tools, Projects etc.
In Slicer if i select Jan it should filter Jan and show in 1st view and  in the same slicer if i select Feb it should show Feb. Basically need to compare two months one below other.Thanks in advance

[v-xicai]

Hi  @harshagraj  ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

Hi @harshagraj ,

You may create bookmarks for every Month selected options, for references: Dynamic Visuals using Buttons , Use bookmarks to share insights and build stories in Power BI .

Best Regards,

Amy 

Community Support Team _ Amy

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

[amitchandak]

@harshagraj , Not very clear. The only thing I can suggest is to take min value as a filter in one measure and max value as a filter in another measure. But there are a lot of ifs buts

Measure 1=
var _min = minx(Table,Table[Month])
return
calculate(Table[Value],filter(Table,Table[Month]=_min))

Measure 2 =
var _max = maxx(Table,Table[Month])
return
calculate(Table[Value],filter(all(Table),Table[Month]=_max))

[parry2k]

@harshagraj not sure how your tables are related and which tables you are using for the slicer. What happens if you select both Jan and Feb now?

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[harshagraj]

Hi @parry2k thank you for looking into this. Sorry for not giving clear idea. The Table is history table it has Date column called History Date. In the same table We have Tool Number, Project Number etc column also. I have to use History Date[Month] in Slicer. I need two views one below the other. Its a single selection. If in slicer 1 i select Jan the bar chart displays the data with all year Month Eg Jan 18, Jan 19, Jan 20 etc . In Slicer 2 if u select Feb it will show Feb 18, Feb 19, Feb 20.