About matrix graph data display problem

[Anonymous]

hi all

I have a problem with matrix diagrams

You can see this picture, there are three columns of data under the Menlo park column, and I want to show not the ALL_COUNT and SCALE columns under the location column, but only those two columns under the total column,

Is that possible？Let me know if you have thinks

Best Regards

alan-li

[Anonymous]

Hi @Anonymous , if you need to show
On_TIME and [ALL_COUNT+SCALE] as two columns you better create two separate mesures - SUMM for ALL_COUNT as first column and SUMX for [ALL_COUNT+SCALE] as second column and use them to build your table. As result you will have a table with 3 columns - location, your seconf mesure and your third mesure

[Anonymous]

hi @Anonymous 

I mean show it like this

Is that possible

Best Regards

alan-li

[Ashish_Mathur · Accepted solution]

No, I do not think that is possible.

[Anonymous]

hi @Ashish_Mathur 

About the Power BI Desktop connection to the WEB, is there any data limit?I don't see it on the document

Best Regards

alan-li

[Ashish_Mathur]

I do not have the answer to that question.

[Anonymous]

hi @Ashish_Mathur 

all right,  thinks

Best Regards

alan-li