cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
TzachiGolan Frequent Visitor
Frequent Visitor

YTD BUTTON SLICER

Hello all 

I need to create a YTD  slicer  button 

is it possible in DAX without attaching any measure ? 

if so i'd like to know how 

thanks !

4 REPLIES 4
JosefPrakljacic Senior Member
Senior Member

Re: YTD BUTTON SLICER

Hey @TzachiGolan,

 

would you please give us an example of your expected result?

 

What is a "slicer button"?

 

And I would say that you are going to need DAX but till I don't know what a "YTD Slicer Button" is - its just a big guessing game.

 

Hint: Its not a shame to also provide some sample data - just sayin 🙂

 

BR,

Josef

TzachiGolan Frequent Visitor
Frequent Visitor

Re: YTD BUTTON SLICER

Hi @JosefPrakljacic 

 

I have a slicer panel that contains date slicers such a ALL TIME , LAST 7 DAYS , LAST 30 DAYS , and a DATE RANGE - all in a separated chicletslicer buttons . 

Also , today , for YTD button I use a fillter on 2019 and i want to replace it with a set formula so i wont have to change the year manualy each january  ... 

it looks like this - YTD

                            2019

TzachiGolan Frequent Visitor
Frequent Visitor

Re: YTD BUTTON SLICER

HI @JosefPrakljacic  - 

How can I calculate YTD into a new column in a Date table ? 

JosefPrakljacic Senior Member
Senior Member

Re: YTD BUTTON SLICER

Hey @TzachiGolan ,

 

its hard to understand what you want to achieve.

 

Here you can find how to calculate a ytd. 

Here you see how you can put measures (like your ytd) in a slicer so you can select the respective ytd[2018,2019] etc.

 

Please give me a bit more info.

 

BR,

Josef

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)