topic FILTER CONTEXT IN TABLE VISUAL in DAX Commands and Tips

FILTER CONTEXT IN TABLE VISUAL

FrankWoodyblue — Sat, 24 Dec 2022 16:13:18 GMT

Hello, I have a doubt regarding the use of the visual table, according to the image below I have a table that has two rows A with the same values in the column but the ID are different. If I simply drag the values to the table, power Bi considers only one line for the A values as shown below.

However, I would like to display the two values referring to line A as shown in the image below

However I would not want the ID column to be in the table visual.
I have already explored the option not to summarize but it still does not display another value from line A.

AlB amitchandak FreemanZ

Re: FILTER CONTEXT IN TABLE VISUAL

AlB — Sat, 24 Dec 2022 15:45:30 GMT

Hi FrankWoodyblue

Try keeping ID in the table but reducing the width of that column to (almost) zero so that the column is actually not shown

Without that column the As will be shown only once since all the values in the row are the same

Please accept the solution when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Re: FILTER CONTEXT IN TABLE VISUAL

FrankWoodyblue — Sat, 24 Dec 2022 16:01:42 GMT

Thank you for your replay but I cant do that couse in this case I'm use number's as ID to do a example but at the original context the ID are largest text so when I reducing the width of that column the height is distorted.
I thought a have to do a measure that return the description but using the ID as a filter to show all lines without resume. But I dont know how to write it. Could you help me ?

Re: FILTER CONTEXT IN TABLE VISUAL

tamerj1 — Sat, 24 Dec 2022 16:28:53 GMT

Hi FrankWoodyblue
You can create a new column as folows and then use it in the table

DESCRIPTION2 = 'Table'[DESCRIPTION] & REPT ( UNICHAR ( 13 ), 'Table'[ID] )

Re: FILTER CONTEXT IN TABLE VISUAL

FrankWoodyblue — Sat, 24 Dec 2022 21:10:11 GMT

Thanks for your anwser.
1º but the ID are text like this "TKlyl6DaVk6_R4dEG3LGgGUAKQif" so the dax formular can't convert the text to integer.
2º But Ive go to power query and creat a INDICE collumn so used it inside the dax formula that you posted. So it's solved.
3º Two doubt, this result can compromet the original values of the description ?
can I transforme this calculate colllumn in measure ?

Re: FILTER CONTEXT IN TABLE VISUAL

tamerj1 — Sat, 24 Dec 2022 21:32:56 GMT

FrankWoodyblue

2. Nothing that cannot be handled.
3. the column is required to slice by. You cannot slice by a measure