Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi everyone. This is frustrating because although I'm new and learning, I feel this should be simple.
I have two tables: one big table showing smoking rates and another with 3 rows that shows commentary I'd like to appear when Male, Female or All is selected on the slicer.
Table 1 Smoking Rates
Table 2 - Comments
I have linked them as follows.
This is my viz:
The idea is that when "Female" is selected on the dropdown, it will show the female line chart (which it is), but also only the row relating to Females in the commentary. Currently, despite linking the charts, it is showing commentary for males, females and all.
I have tried playing around with the direction of the relationship but nothing seems to work.
Can someone enlighten me as to what I'm doing wrong?
Many thanks!
Solved! Go to Solution.
You have to trim the Gender column in the Smoking rate table since it is having additional blank spaces it is not giving the expected result. If you go to the Power query editor and under thre transform you can see format option click that and use trim after selecting the Gender column from the Smoking rate table.
Thanks
Arul
Hey Arul - thank you so much! I often have this problem in Excel so I should've thought of it. Great pick up and I'll definitely remember this going forward. Thanks again!!!
I think in slicers you are using Gender column from smoking rate table instead from smoking comment table. I assume that filtering direction singlre from Smoking comment->Smoking rate (1:*). If that is the case Gender column in Smoking comment table won't be filtered by Smoking rate table Gender column since filtering won't happen from Smoking rate table to Smoking comment.
Thanks,
Arul
Thanks Arul.
Yes, I was using Gender from the Smoking Rate table. So I have changed it to Gender from the Comment table.
This is how the data model is set up:
However, now when I filter on Female, the Comment table filters, but all my line graphs have disappeared.
Thanks for your help, but any further thoughts on what the issue it?
Many thanks, Andrew
Hey Arul - no measures involved, it's meant to be simple with just columns and tables. The file can be downloaded here
Thanks in advance, Andrew
You have to trim the Gender column in the Smoking rate table since it is having additional blank spaces it is not giving the expected result. If you go to the Power query editor and under thre transform you can see format option click that and use trim after selecting the Gender column from the Smoking rate table.
Thanks
Arul
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
93 | |
88 | |
35 | |
35 |
User | Count |
---|---|
154 | |
101 | |
80 | |
63 | |
54 |