Forum Discussion

paynemiller's avatar
paynemiller
Regular Visitor
9 years ago

Need Help understanding Matrix dataMapping

Hey All,    I have this dataset:  Gym Name Department Name Total Sales Total Profit Top Upper Target Lower Bottom Lower Color Lower Middle Color Middle Color Middle Upper Color Upp...
Need Help
Tips and Tricks
v-viig's avatar
v-viig
Community Champion
9 years ago

Thanks for the clarification.

Could you please share your data-set to investigate the issue with data-mapping?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

[email protected]

paynemiller's avatar
paynemiller
Regular Visitor
9 years ago

Sure thing!

Below is my data set (imported into PowerBI from Excel)

 

Gym Name	Metric Name	Metric Value	Top	Upper	Target	Lower	Bottom	Lower Color	Lower Middle Color	Middle Color	Middle Upper Color	Upper Color	ID
Gym1	Membership Sales	1000	1000	750	500	250	0	#dc3c2e	#e57d2d	#ffffff	#7f1f86	#0094e2	1
Gym1	Apparel Sales	100	100	75	50	250	0	#dc3c2e	#e57d2d	#ffffff	#7f1f87	#0094e3	1
Gym1	Equipment Sales	500	250	125	75	25	0	#dc3c2e	#e57d2d	#ffffff	#7f1f88	#0094e4	1
Gym2	Membership Sales	2000	2500	2000	1500	1000	0	#ffffff	#ffffff	#000000	#e3cf0b	#e3cf0b	2
Gym2	Apparel Sales	200	100	75	50	15	0	#ffffff	#ffffff	#000001	#e3cf0b	#e3cf0b	2
Gym2	Equipment Sales	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2
  • v-viig's avatar
    v-viig
    Community Champion
    9 years ago

    This is dataView object that has been got using your capabilties and data-set.

    There're no null values.

     

    Are you still able to reproduce the issue? If so, please provide extra repro steps if that 's possbile.