Forum Discussion
Need Help understanding Matrix dataMapping
Hello paynemiller,
I'm wondering why you prefer matrix than table data mapping. Could you please describe your case?
I suppose that it'd be better to use table data-mapping instead.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
v-viig Well, we are trying to achieve an extension of the current "out-of-the-box" Matrix provided by Power BI. We would like to be able to color code certain fields based on mathematical conditions. I reviewed the Data Mapping Documentation at GitHub, however, there is no matrix section. I assume the matrix data mapping is how we achieve the matrix vizulaization, we need multiple columns, multiple rows, all with related values.
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
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
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.