Reply
LBRo
New Member
Partially syndicated - Outbound

How can I rename blanks in a graph that displays values for related and not related records?

Hello!

 

I have 2 tables related by ID. Table 1, has groups A, B, and C. Table 1 has IDs from 1 to 5, while Table 2 has IDs from 1 to 10. Not all Table 1 IDs are in Table 2. When I create a chart with values from Table 2 and the classification from Table 1, there's a bar that appears blank for the non-related IDs. How can I change the name on the X-axis to display A, B, C, and "Not in a group" 

LBRo_0-1705119826756.png

 

I would like to create this chart without excluding the blanks but renaming them.

LBRo_1-1705119904614.png

 

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Syndicated - Outbound

Hi @LBRo 

You can add a calculated column :

Group = LOOKUPVALUE(Groups[Group],[Id],[ID],"Others")
And use it on the graph
Ritaf1983_0-1705131350943.pngRitaf1983_1-1705131389308.png

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Yi

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

3 REPLIES 3
LBRo
New Member

Syndicated - Outbound

Thanks! it worked out. 

Syndicated - Outbound

Same idea but using the data model and COALESCE

 

lbendlin_0-1705185837890.png

 

Ritaf1983
Super User
Super User

Syndicated - Outbound

Hi @LBRo 

You can add a calculated column :

Group = LOOKUPVALUE(Groups[Group],[Id],[ID],"Others")
And use it on the graph
Ritaf1983_0-1705131350943.pngRitaf1983_1-1705131389308.png

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Yi

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)