cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarcS
Helper I
Helper I

4 tables with 3 slicer in relationship | dependence problem

Hi,

 

need some help with the relationship between four tables and slicers.

 

Following situation: I have a large approx table with so following rows:

ApproxTable:

datehourclientIDappIdcontentIDreachpersonmapstreet
2019-10-121ABC143784MiketrueLondonstreet
2019-10-122ABC231102TimtrueBerlinstreet
2019-10-131ABC1989PaulfalseLondonstreet
2019-10-133XYZ31278TimfalseParisstreet

 

I have a content client Mapping table

MappingTable:

clientIDappIDcontentID
ABC143
ABC19
ABC231
ABC439
XYZ31
XYZ527

 

And two tables for content and app informations:

ContentTable:

contentIDcontentNamecontentImage
1Content1link zu ContentImage1
9Content9link zu ContentImage9
27Content27link zu ContentImage27
31Content31link zu ContentImage31
39Content39link zu ContentImage39
43Content43link zu ContentImage43

 

AppTable:

appIDappNameappImage
1App1link zu AppImage1
2App2link zu AppImage2
3App3link zu AppImage3
4App4link zu AppImage4
5App5link zu AppImage5

 

Now i want to slice the approx table information with three slicers: 1. clientID 2. appID 3. contentID

And if ClientID selected over slicer 1. => Slice2 and 3 lists only the available appIDs and contentIDs which are available in the approx table.

 

I tried every combination of relationships between this 4 tables. Created new tables with unique ids and try to related to the other. But nothing works for me. I build the following relationship model:

 

approx n:1 contentInf (over contentID) (direction content -> approx)

approx n:1 appInf (over appID) (direction app -> approx))

approx n:n mapping (over clientID) (direction mapping -> approx))

 

In this case i can slice the approx information but the slicers has no relationship between each other.

 

Would be thankful for helping answers.

Bg

2 REPLIES 2
kentyler
Solution Sage
Solution Sage

Power BI can make you pull your hair out sometimes.

I copied your samples into excel and then loaded them in power bi

i did not use your Map table since the relationships in power bi allow me to make the same mapping

3slicers.png

i then created a report with 3 slicers ( the slicers are just table elements with one field from approx table dragged onto them) and one table... i wrote no code

 

 

3slicerreport.png

When you select an appid, the other 2 slicers show the clientid and contentid values available for that app id. and the full table display shows all the candidate rows

if you select one of the 2 content ids available, the full table will only show that content row.

This all happens because if the relationships and how power bi hooks up the graphical elements. It gets me every time... i ALWAYS start out trying to do way to much work in code to make things work..... 🙂

I think this is what you were looking for...if not let me know and we'll have another go at it.





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Hi thanks,

 

thats good but i want that the slicer shows the app name, client name and content name, not the ids. So i have to merge the approx with the content and app table over the contentName, appName and put this new approx rows to the slicer? 

 

Edit:

 

I tried your relationship model. And i have to clients: ABC and XYZ.  ABC has only the apps 1,2,4 and XYZ: 3,5. So if i select abc the slicer has to filter the apps which depends to the client. 

 

Client slicer: ABC

App slicers hast to show only:: 1,2,4

Content slicers has to show only: 9, 31, 39, 43

 

If i select

Client: ABC

App: 1

Content slivers hast to show only: 9,43

 

BG

 

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.