Forum Discussion
slicer without merging
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.
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
5 Replies
- amitchandak
Super User
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
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