One Dimension Filters Another Dimension in Power BI
Вставка
- Опубліковано 19 лип 2020
- I often get this question after I explain about the star-schema. The question is that both my dimensions are filtering my fact table values, but how can I get one dimension filtering another dimension? for example, how can I get only the list of products that have been purchased by this customer? In this video, I’ll explain how you can do that with the star-schema.
Download the sample file from my article here:
radacad.com/one-dimension-fil...
*******************
Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.
RADACAD courses: learn.radacad.com
Become an academy member: learn.radacad.com/academy/
*******************
********
CONNECT with US!
********
-- / radacad_com
-- / rad_reza
-- / leila_etaati
-- / radacad
-- / leila-etaati-b0304636
-- / rezarad
-- / 6393399
-- radacad.com
******** - Наука та технологія
so simple yet wow i've been looking for this
Simple and helpful
This really is a wonderful technique
Nice and simple
YOU ARE AWESOME BUDDY! BRILLIANT JOB
Thank you!
Amazing!
Amazing, could you xplain what are the basics of under the hoods on what is happening
Super Training. Where Can I get the data set? with all dimension and fact tables. not powerBI reports. Can I have the link please
Great tip, but it has some cumbersome. Imagine scenario where you select 1st customer from slicer who bought just red and blue products and then you select blue product on product slicer. Then you change Customer slicer to show 2nd customer who just bought red product. You will still have selection on product slicer blue, because you selected this for 1st customer. Could you please tell me how to make this 2nd slicer (product color) being automatically 'cleared' from previous selection when you change your customer ?
Ok, cool. But what if I use filter pane to filter the dimensions? I cannot filter another filter.
Hi,
I need your suggestion for how to approach to create this report
Scenario: I want to build something like a quick comparison to identify the Sales gap of a client (Slicer) between last year vs Current year by product
by Month
Example: Last yr a Client bought 10 products Worth $1,20,000 in July
Current situation is CY($70,000) - LY($1,20,000) = $-50,000 (which is easy to calculate)
Now I want to build a dashboard which can dig deeper and can identify the reasons of the GAP
There can be 5 reasons for GAP
1) Few products didn't get sold this year (Cancel)
2) Few products got sold before July (Early Renewal)
3) Few products got Postponed (Late Renewal)
4) Products booked with less value (Discount)
5) New product Sold this year (New)
I have been doing this evaluation manually But is there a way if I can click a client of a slicer, it can show me the above 5 reasons...