Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm building a column chart that shows the sales of differents clients and the chart can by dynamic changed by the viewer. When it changes, I'd like that the chart showed just the data of that specific cliente that I want to see, as well the start date of the chart should the start date that the client begin to shop in my store.
However, when I filter the clients, it shows all the data and date together, what makes a little bit durty, like the image bellow:
How can I build this chart to show only the client that I filtered?
Solved! Go to Solution.
Hi !
While plotting the chart, you are using Date column from Calendar dimension. If yes please also check that checked do no show blank rows property.
Regards,
Hi !
Do you have any date dimension in your model.
Please share your current Model view diagram.
Regards,
Hasham
I'm not sure if it will be usefull, it's in portuguese:
Hi @Anonymous ,
I didn't find a column named "Client" in your model. Could you check the relationship between the table with "Client" column and other tables?
Best Regards,
Icey
Hi !
While plotting the chart, you are using Date column from Calendar dimension. If yes please also check that checked do no show blank rows property.
Regards,
@Anonymous
How is your data model setup? Have you set up clients on a separate table or all of your data sit on a single table?
Insert a slicer for the clients and filter prior to viewing the chart in focus mode
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
It's all in the same table, the "sales table". It already has a slicer, but when I filter by client, the chart shows all the data, and I want to show just the slicer data
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
7 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
11 | |
5 | |
5 | |
2 |