slicer without merging

[Anonymous]

Hey guys,

first I show the "example" dataset.

(1) I have a main table which shows the messages of customers

(2) Than I have some tables which do a topic modeling with the messages, each table shows the messages for each topic

 my goal: I want to create a slicer which filter the messages with the topics. I visualise the messages and the user should can see the messages then for each topic in 1 slicer.

what I've tryed: I allready try to work with relationships - but there I only get 1 topic to filter. I also merge the topics via power query all in the main table so I get one column which shows for each message the topic. But because there are messages which can get more than one topic, the messages starting copy and the file got to big, so I couldnt refresh the data.

Can I maybe to a measure or something? The problem is, that its a very big file, IF I try solutions in power query the file get so big, each topic have like 2000-5000 Rows and there are like 10 topics.

Thank you.

[amitchandak · Accepted solution]

@Anonymous , My advice would be to combine the last three tables into one and then create only one join,

Before you join them add additional column Message Type -  same as table name( custom column - static text)

and use that as slicer

[Anonymous]

@amitchandak 2 questions: How should I combine the last 3 tables into one? I thought I can only join 1 by one, where can I join 3 at once?

and: There is no possible way to work with measures? 

Thanks 🙂

[amitchandak]

@Anonymous , Append in power query. Hope you want to use that.

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

With three different tables, I think it is more of a bookmark case than a measure slicer.

bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/

If you  can use measure from dimension (means those three tables) you can think of a measure slicer too

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern

[Anonymous]

@amitchandak 

So I append the three topic tables into one, this worked fine.

but the second step I didnt realy get where you wrote "Before you join them add additional column Message Type -  same as table name( custom column - static text)

and use that as slicer"

sorry I need to make sure, to do no unnessary step because of the performance ;D

[amitchandak]

@Anonymous , Oh no need, You already have Topic , which same as table name, I thought there is a little bit of difference, You can use the topic in slicer