Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Dear PBI custom viz developer community,
I have a set of data in the from of
| X Values | Y1 Values | Y2 Values | Overwritten |
| 1 | 50 | 50 | 1 |
| 2 | 45 | 42 | 0 |
| 2 | 47 | 42 | 0 |
| 3 | 33 | 34 | 1 |
| 3 | 31 | 34 | 0 |
| 3 | 30 | 34 | 0 |
| 4 | 21 | 26 | 0 |
| 4 | 10 | 26 | 1 |
I need to create a datamapping to be able to visualise the data
X values are my categorical data,
Y1 values should not be summarised and I am using them to display as a scatterplot,
Y2 values are my summarised data as averages of Y2 at each X1 which I am displaying as a line
Overwritten will be used as my legend, (if the value is 1 show as different colour)
I would need your help to understand what would be the best dataviewmapping for developing a custom visuals given the above data
Appreciate your help
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |