cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

Highlighted
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

Top Solution Authors
Top Kudoed Authors (Last 30 Days)