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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.