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
Baarathi88
Helper III
Helper III

Power BI Table Bar Chart Grey Area

Please find the below image, can i get the grey area in data bar in the power bi table visual as given in the below mockup.

 

 

 

Baarathi88_0-1600167465789.png

DataBar Grey.PNG

5 REPLIES 5
PaulDBrown
Community Champion
Community Champion

@Baarathi88 

Assuming you have a Dimension table for countries, I suggest creating a new column in the Dimension table:

1) In Power Query, create a conditional column whereby if the Country[name] is one of those you need to keep separate, then Country[Name]. If not, "Other"

2) OR in the table list in the report page, you can right click on the Country[name field] in the dimension table and "create a new Group" (one for every seperate country and the rest as "Other")

 

then use that new column in the visual

 

If you get stuck, please provide a sample dataset or PBIX file





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






@PaulDBrown i could not upload the power bi file here. Please provide your mail id. I'll share through mail

@Baarathi88 

You can upload by using a cloud service (Onedrive, Google Drive, iCloud, Deopbox ...) and sharing from there. 
If that doesn't work, send me a pm 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






@Baarathi88 

 

I'm attaching the file. I have created the groups in the "Country Master" Table, in the "Fields" list (I cannot access the source tables in POwer Query since I have no connection to the source database). Ideally you should do this in Power Query if possible.

 

Country Groups.JPG

 

See if that work for you.

PBIX file attached





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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