Forum Discussion
power bi relationships
Hello, I am tring to create a line and stack chart to show the total sales by customer in the columns and the customers forecast (SOP) for each month in the line, I am totally unable to be able to create a link between the selection of the customer in the table and the chart, the All sites works with the calendar on another page in my model, and i wanted to be able to show on another page the breakdown withthe forecast.
Below is the model view
Below is what i am trying to achieve by selecting the customer in the table on the left of the chart
2 Replies
Hi Julier ,
You have provided so little information that I cannot understand what you are trying to accomplish. Could you please provide your sample data and desired results, please?
And here are some suggestions:
If you're not already using a slicer for customer selection, consider adding one to your report. A slicer dedicated to customer selection can effectively filter the data displayed in your charts based on the selected customer.
Check the cross-filtering direction in the relationship between your tables. It should be set in a way that selecting a customer can filter both the sales data and the forecast data. The cross-filter direction can be adjusted in the relationship properties.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hello, I cannot understand why i am unable to create a relationship betwen these 2 tables. I want to be able to show the customers sales against their forecast S&OP for each month
