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

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors