- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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"
I would like to create this chart without excluding the blanks but renaming them.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @LBRo
You can add a calculated column :
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
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks! it worked out.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Same idea but using the data model and COALESCE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @LBRo
You can add a calculated column :
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
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
07-05-2024 01:17 AM | |||
08-27-2024 03:49 PM | |||
01-17-2024 02:55 AM | |||
05-13-2024 11:10 PM | |||
11-03-2023 10:56 AM |
User | Count |
---|---|
113 | |
76 | |
56 | |
55 | |
43 |
User | Count |
---|---|
183 | |
120 | |
80 | |
67 | |
57 |