Forum Discussion
Please help a newbie with very simple static table
HI mvi
One approach is to model your data like this
and then you can configure the matrix visual like this
Here is a PBIX File for you to try : https://1drv.ms/u/s!AtDlC2rep7a-xiyUQSVxIhW5uZeQ?e=QS3s71
Hi mvi
Not quite understand your requirement. Do you mean the Value should be a measure rather than a column? It doesn't matter. you can replace the field with measure, such as:
Hi mvi
You can double click the column name in the filed as below:
Please kindly mark my answer as a solution if it helps, thanks a lot!
Microsoft EmployeeHI mvi
One approach is to model your data like this
and then you can configure the matrix visual like this
Here is a PBIX File for you to try : https://1drv.ms/u/s!AtDlC2rep7a-xiyUQSVxIhW5uZeQ?e=QS3s71
Thanks Phil!
How do I replace the 100 and 200 values with actual counts (measures) from my SQL Server database?
Thanks again!
- v-diye-msft
Community Support
Hi mvi
Not quite understand your requirement. Do you mean the Value should be a measure rather than a column? It doesn't matter. you can replace the field with measure, such as:
Thank you!
One last question: how to I change column captions in the table, such as "ValueMeasure"?
