cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Zzema Frequent Visitor
Frequent Visitor

Work with table (I can't edit visualisation)

 

Hello, I have this table:

9657cdb907.jpg

But I can't do this table. How I can do this?

1492076149074.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Work with table (I can't edit visualisation)

Hi @Zzema,

 

I don't think matrix column will support for these values.

 

In my opinion, I'd like to suggest you click enter to query editor use "unpivot table" function to convert query, then save change and use matrix work on the new table.

 

Steps:
1. Click on query editor.
2. Right click on current query and choose the reference function.
3. Navigate to referenced query, choose these value column and click on "unpivot table" button.(transform tab -> unpivot table)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
5 REPLIES 5
Zzema Frequent Visitor
Frequent Visitor

Re: Work with table (I can't edit visualisation)

Anybody now, how decide this problem?

Zzema Frequent Visitor
Frequent Visitor

Re: Work with table (I can't edit visualisation)

Or maybe someone know, how I can brushed different grids (borders). But change the level of the column name of the date and the name of the fields used is more important

Community Support Team
Community Support Team

Re: Work with table (I can't edit visualisation)

Hi @Zzema,

 

You can simply switch the column field order and turn on the grid to achieve your requirement:

 

Capture.PNGOriginal VisualCapture2.PNGmodify the columns orderCapture3.PNGturn on the grid line

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Zzema Frequent Visitor
Frequent Visitor

Re: Work with table (I can't edit visualisation)

@v-shex-msft HI. Very glad to see you answer. But my fields (traffic, orders,revenue etc) is not columns, its a values. 

Is this a solvable problem?

2eec70d3a3.jpg

Community Support Team
Community Support Team

Re: Work with table (I can't edit visualisation)

Hi @Zzema,

 

I don't think matrix column will support for these values.

 

In my opinion, I'd like to suggest you click enter to query editor use "unpivot table" function to convert query, then save change and use matrix work on the new table.

 

Steps:
1. Click on query editor.
2. Right click on current query and choose the reference function.
3. Navigate to referenced query, choose these value column and click on "unpivot table" button.(transform tab -> unpivot table)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |