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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Mydauldron
Frequent Visitor

Link Count from 3 items to one.

Not sure where this would go. 

 

I have what we call Server builds listed as AWS, Azure, Google, and On Prim.  Management wants a listing of each and alwo to combine the count for the Cloud Three . AWS, Azure, Google.  

 

Right now I can show AWS 100 systems, Azure 2000 systems, and Google 40 Systems, what i want is a Virual showing Cloud 2140 total systems. 

 

Tried Filter Options, Visualizations by putting Location for the 4 types and OS set to count, which gives me the totals for each, but not total. 

 

5 REPLIES 5
Mydauldron
Frequent Visitor

in doing so I get totals for Each type of Platform but not the total of all three that I can put in a visual and select, also when I do this it removes everything else except the new table data of the column I select. 

In my Pie Chart i have the one on the left, what I need is on the right in red (All Cloud). 

So when selected my Table visual will show all but "On prem" data. 

 

BuildOnPlatform1.pngBuildOnPlatform2.png 

 

 

 

 

Do not duplicate data in a visual. That is a UX red flag.

Thank you for engaging and trying to help,  I have been doing PBI for about a year now.

 

Yeah don't know what the UX Red flag is. 

 

my inventory for Windows Servers is around 21,000 systems of which about 3,200 are Azure, 100 is AWS and 51 are Google, the rest some 17,000 are Physical, VMWare, Cirrus what we call On Prem. 

Management wants a listing of all but wants to be able to select CLOUD and only see the Total of whats in the Cloud, i have them totaled but not together, and everytime I try On Prem is shown also. 

 

 

see attached

lbendlin
Super User
Super User

Explore Column groups  (right click a column, New Group).  That should suffice.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors