Forum Discussion
Table Visual Filter
Anonymous ,
No need to show real data, you can always create some short dummy dataset to illustrate your issue.
Anyway, it is always better to provide
1. Sample (dummy dataset) data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1 to 2.It will increase your chances to get an answer as no one wants to retype your data from an image.
For your case, if I understood you correctly, you can try this measure and use it as a filter on the visual (showElm is 1):
showElm = SWITCH ( TRUE (), SELECTEDVALUE ( T[Course] ) = "a" && SELECTEDVALUE ( T[Complete] ) = "no", 1, SELECTEDVALUE ( T[Course] ) = "b" && SELECTEDVALUE ( T[Complete] ) = "no" && SELECTEDVALUE ( T[Mgr] ) = "yes", 1, 0 )If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
Sorry but the data is quite sensitive and I'm prohibited from posting it here by the firm I work for. Hower I have created a mock up of what I'm trying to do. The data below shows two courses as mentioned above. I have a table visual in BI that shows the staff name, Line Manger and a few other pieces of data based on the courses not being complete. I have a slicer showing both courses. What I would like to have is if i choose Course A, ALL staff, be they manager or not, who have not completed will show in my table visual. If I choose Course B then only managers that have not completed will show in the table visual (highlighted purple in the data set above.
Anonymous ,
No need to show real data, you can always create some short dummy dataset to illustrate your issue.
Anyway, it is always better to provide
1. Sample (dummy dataset) data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1 to 2.
It will increase your chances to get an answer as no one wants to retype your data from an image.
For your case, if I understood you correctly, you can try this measure and use it as a filter on the visual (showElm is 1):
showElm =
SWITCH (
TRUE (),
SELECTEDVALUE ( T[Course] ) = "a" && SELECTEDVALUE ( T[Complete] ) = "no", 1,
SELECTEDVALUE ( T[Course] ) = "b" && SELECTEDVALUE ( T[Complete] ) = "no"
&& SELECTEDVALUE ( T[Mgr] ) = "yes", 1,
0
)If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.