Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey guys,
I created a custom table as you can see here:
I am sorting the column "Status" using the column "Preset order".
After that, I created a filter and connected it to my custom table:
Two fields from the column "Status" in my table | Settings of the filter |
|
|
This was the preparation for filtering the complete report. Now I need to connect this filter to my data model.
In my data model I have a column with a lot different entries, but they can be split up in the two entries of my custom table.
Here is an example:
Custom table field | Data model fields (all in one column) |
Meldungen in Arbeit (Example A) | MIAR OFMA GNOK IT MIAR AMER GNOK RC |
Abgeschlossene Meldungen (Example B) | MMAB AMER GNOK RS MMAB OFMA LÖVM GNPF IT MMAB AMER GNOK IT CINF |
How can I assign the entries of my data model to the two different entries of my custom table/filter? This would be very nice to have an easy filter method for the complete report.
Do you have any idea how to do that?
Thanks in advance!
Solved! Go to Solution.
Thank you for your answers!
It turned out, that it was a lot easier to just "translate" the data model field with the original status (e.g. "MIAR OFMA") to the desired status (e.g. "Notification closed").
I did this with the CONTAINSSTRING-function in a new column, which is giving me a TRUE or FALSE.
This TRUE or FALSE is translated to "Notification closed" or "Notification in progess" with a simple if-function in a seperate new column.
The first four letters of the original status are containing enough information for me to distinguish between "Notification closed" or "Notification in progess".
I don´t know if thats a super clean solution, but it works for me.
Thanks again!
Thank you for your answers!
It turned out, that it was a lot easier to just "translate" the data model field with the original status (e.g. "MIAR OFMA") to the desired status (e.g. "Notification closed").
I did this with the CONTAINSSTRING-function in a new column, which is giving me a TRUE or FALSE.
This TRUE or FALSE is translated to "Notification closed" or "Notification in progess" with a simple if-function in a seperate new column.
The first four letters of the original status are containing enough information for me to distinguish between "Notification closed" or "Notification in progess".
I don´t know if thats a super clean solution, but it works for me.
Thanks again!
Hi,
Not sure of what you want but try this. In the Query Editor, split the second column by rows. Now create a relationship (Many to One and single) from the first column of the table to the first column of the Custom table.
Learn about Column Groups. You may not even need the custom table.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |