Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi I'm pretty new to Power BI and having one clarification
I have data as Year,Month,Week,Date in table and created slicers to filter the data in power BI , I need to create 2 filter Yesterday/Today , If user click on Today or Yesterday data should display , I'm aware that user can select year then Month,week,day but i'm trying to avoid as many as user clicks, I want user to get data straight away if he/she clicks on slicer(Yest/today)
Thank you in advance, if possible please share documents for learning power BI 🙂
You could add 2 calculated columns and use these as slicers:
IsToday = IF(Table1[Date] = TODAY(),TRUE(),FALSE())
IsYesterday = IF(DATEADD(Table1[Date],1,DAY) = TODAY(),TRUE(),FALSE())
Hope this helps
JJ
Thanks for response, it did works!, but i'm looking something different than this!, Please see below screen shot for reference
Can we get Mutli circle progras wheel in power BI, Thanks for your help!, Much appreciated
Ok, so you can create a custom column:
Slicer =IF(DATEADD(Table1[Date],1;DAY) = TODAY(),"Yesterday",IF(Table1[Date] = TODAY(),"Today","Before Yesterday"))
An then use this as slicer:
Is this what you are looking for?
how can I made slicer like this?
I mean, how to customize the table data and get that slicer as the result?
@DoubleJ wrote:Ok, so you can create a custom column:
Slicer =IF(DATEADD(Table1[Date],1;DAY) = TODAY(),"Yesterday",IF(Table1[Date] = TODAY(),"Today","Before Yesterday"))An then use this as slicer:
Is this what you are looking for?
Excellent it works!, thanks for help!, is it possible to hide before yesterday in slicer?, i need only today and yesterday
Thanks for your help!
I haven't got any answer yet!
I'm afraid this is not possible
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |