Solved: Show current month bar by default

Anonymous · ‎10-07-2021

I have a requirement where I have a bar graph in with sales as measure and year-month as dimension. I have slicer value month-year

requirement : If nothing is selected from month year I need to show current month sales in bar graph. if there is one or more selections I need to show values for those month - year selected.

for example if I have data like below, if nothing is selected I have to show value 7229 in bar graph as a single bar, if for example Jan 2021, August 2021, October 2021 is selected it should show relevant values in relevant bars

Month Year	Sales
Jan 2021	19302
Feb 2021	6473
Mar 2021	7618
Apr 2021	7392
June 2021	85753
July 2021	68292
August 2021	62292
September 2021	73627
October 2021	7229

Jihwan_Kim · ‎10-07-2021

Link to the pbix file

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

View solution in original post

Jihwan_Kim · ‎10-07-2021

Link to the pbix file

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page