Forum Discussion
Helper IIYou can't create a relationship between these two columns because one of the columns must have uniqu
Hello, don075 ,
the issuse is that you don't have any match, because you have different formatting:
Trns:BridgeTable
Crumb
if I create temporary one, it works just fine:
Super Userhello don075
i am not sure but if there is no measure perhaps that is a relationship problem since it looks like to be connected through blank value.
i believe the smonth in slicer should be taken from table with relationship with data in table visual.
if possible, please share your sample pbix with removing any confidential information.
Thank you.
Helper III have attached the report. recreated the report with ImportData. My original report was created with DirectQuery. This thread won't let me upload the file. I am including the google share link to the file.
https://drive.google.com/file/d/163e3hhTqZaL-7Z-BfbRFC8N_hPNxdSJ5/view?usp=sharing
- vojtechsima
Hello, don075 ,
the issuse is that you don't have any match, because you have different formatting:
Trns:BridgeTable
Crumb
if I create temporary one, it works just fine:
- don075
Thanks a lot. Silly mistake by me. I had to make one more change to the relationship.
In the link between BridgeTable and Trns, had to select "Both" for "Cross filter direction"