Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

About matrix graph data display problem

hi all

 

I have a problem with matrix diagrams

aaaa.png

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

1 ACCEPTED SOLUTION

No, I do not think that is possible.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

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
Not applicable

hi @Anonymous 

 

I mean show it like this

 

aaaa.png

Is that possible

 

Best Regards

alan-li

No, I do not think that is possible.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

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

I do not have the answer to that question.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

hi @Ashish_Mathur 

 

all right,  thinks

 

Best Regards

alan-li

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.