Тёмный

Power BI - Filter by a Measure in a Slicer 

BI Elite
Подписаться 71 тыс.
Просмотров 184 тыс.
50% 1

Check out this awesome Power BI tutorial on how to add a filter by a measure! This isn't possible by default, so I will show you how to work around it and slice by a measure!
To enroll in my introductory or advanced Power BI courses:
training.bielite.com/
Elite Power BI Consulting:
bielite.com/
Data Insights Tools:
www.impktful.com/
Connect with me on Twitter!
/ powerbielite

Опубликовано:

 

20 июл 2020

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 172   
@nitinrungta3320
@nitinrungta3320 Год назад
First, you came to the point and solved the problem of getting measure in a slicer. Then you anticipated all other aftermath problems I might face and solved that. GENIUS!!
@kageri4334
@kageri4334 2 года назад
Excellent! 3 bullseyes!!! Brief, concise and precise presentation. Exactly the "how to" I am looking for. Thank you so much for sharing. More power to you.
@shekharshrestha4072
@shekharshrestha4072 2 года назад
I always thought that there was a way to it, I could do everything but could make those slicers interactive.
@vinciallen-steward2088
@vinciallen-steward2088 2 года назад
This is fantastic! Great video. Well explained and articulated! Thank you so much.
@mohitmanwani5298
@mohitmanwani5298 3 года назад
As always, crisp and clear explanation. Thanks mate for amazing video
@MrAszpic
@MrAszpic 3 года назад
This DAX tricks are something that really add up to your channel, please keep it up!
@yosiwolf6927
@yosiwolf6927 Год назад
This is super helpful, thanks!! I applied this to a date range, to filter by IDs who are associated with a Max Date (measure) that falls within a slicer period.
@roqueduarte3422
@roqueduarte3422 2 года назад
Great video. I am coming into this quite late so you may have update this already, but just thought i would add the following: Once that generated value table is created you can easily apply simply calc columns to give you a text based slice option. This works really well for me in a similar example where the sales value is then grouped into "0-100k", "101k-499k", "500k-1mil" etc etc and one can then slice using this column and it works exactly the same was as using the value column in the final slicer :)
@HavensConsulting
@HavensConsulting 3 года назад
Good stuff parker. Having a "values" between filter is a great integration for many reports
@ocoo1982
Amazing video, super clear and short. Thanks a lot!!!
@raymondhof7828
@raymondhof7828 3 года назад
I've been searching for something like this for away to create a dynamic sample data table. Thanks, very easy to follow
@Adin7785
@Adin7785 3 года назад
This was very helpful! Thank you so much for sharing your insights.
@sezoinside7320
@sezoinside7320 3 года назад
Thank you so much, I was really struggling with this one 💯
@cankirgiz
@cankirgiz 3 года назад
It really worked for my use case. Thank you so much!
@surajbatra8004
@surajbatra8004 3 года назад
A very neat trick, I was searching for it so so long
@karloisaac2597
@karloisaac2597 Год назад
Thank you so much! I've been facing the problem of making the slider ranges dynamic and I just couldn't wrap my head around this problem; I've been fighting with this for days! Thaaaanks!!!
@dgibbons82
@dgibbons82 3 года назад
Thanks for the video! I was able to use this to design a slicer that filters by the active logged-in user! Awesome!
@danielsiffredi8403
@danielsiffredi8403 3 года назад
Excellent technique. Thanks for sharing!!
@kadirkkkk
@kadirkkkk 2 года назад
So easy and so useful. Thank you so much
@dcamrine
@dcamrine 3 года назад
Great example! Looking forward to using this.
Далее
Slicing by Measure Categories in Power BI
10:42
Просмотров 55 тыс.
Change Measure using a Slicer
9:12
Просмотров 58 тыс.
Filtering calculation items in a slicer
11:24
Просмотров 15 тыс.
Build a DATE PICKER in Power BI Desktop
10:14
Просмотров 200 тыс.
Deep dive into measure filters in Power BI Desktop
23:03
DAX Fridays #204: Slice by the results of a measure
10:59
📊 How to use Power BI DAX - Tutorial
37:28
Просмотров 1 млн