Creating a Matrix Table that shows constant values on the first to columns then values by date.

[James_Gillespie]

Hello, I'm trying to create a matrix, (or another visual) like what is shown below. 

Where the first 3 columns show what is being measured, the low and hig control limits. Then the actual data points.

I currently have the table showing me the parameter and the data points but I'd really like to include the limits on the table. As shown below. 

Any tips on how how to accomplish this task? 

I have two incoming queries. One with the "parameter", date, and values. The second with the "parameter" and high and low limits. They are related by the "parameter". 

[v-xicai]

Hi @James_Gillespie ,

Currently, it is not supported to display multiple columns or measures in the first column of Matrix visual. And the Drill down  mode which put multiple columns or measures into the same Columns or Values box of Matrix may be not your demand.

As workaround, you may create a tooltip for the Matrix visual, which displays [Low Limit] , [High Limit] and [Parameter] using Table or Matrix visual. See more:Create tooltips based on report pages in Power BI Desktop.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[James_Gillespie · Accepted solution]

Amy, 

Thanks for your ideas. I was able to use the drill down to display what I wanted after some changes in formatting. 

Here is a link to the site that guided me through the process: https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[nvprasad]

Hi,

Create a calculated table of date, PH & Conductivity columns then add limits using union and rows function to the calculated table as two more data points. 

This way you can get the expected output.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,

Venkata Nalla

[James_Gillespie]

Venkata, 

I'm sure that your solution would work if I was more familiar with coding. But I figured how to do it another way.