This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Hi there
I'm showing the same data in two different ways: one is a table and the other is a line & stacked column. The target figure for the table shows correctly, yet the target line (same field) is showing some right and more wrong.
For ease, I'll single one person out:
Both visuals use the same selections for: sales person name & target with filters (both set to ignore any phase that has GP in it), and yet one is giving me the correct amount and the graph isn't. Any ideas? Data is currently not filtered to any months, just the year.
Solved! Go to Solution.
@Tahreem24 my bad!
Table -
Graph -
and yes, the status is for won/sales calls, for the Total Won/Total Sales Call, and doesn't interact with the target line.
@smather That's little weird. Try to check the all the filters have been applied on Table and the chart visual.
@smather I can see there is Status column filter have been applied on second image. I meant you need to check the any filtered value by clicking on "Funnel" icon on both the visuals.
@Tahreem24 my bad!
Table -
Graph -
and yes, the status is for won/sales calls, for the Total Won/Total Sales Call, and doesn't interact with the target line.
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 31 | |
| 26 | |
| 23 | |
| 22 | |
| 15 |
| User | Count |
|---|---|
| 62 | |
| 47 | |
| 28 | |
| 24 | |
| 21 |