cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amalrio
Helper V
Helper V

Matrix visual look like a gannt chart

Hi All, 

 

I have my data in a tabel format like below(how my back end PowerBI data table look like.

amalrio_0-1606355262394.png

 

I want to visual that data in a metrix or other sort of visual similar to below.

 

is there a way that I can achieve this feast. 

 

amalrio_1-1606355388371.png

 

 

 

1 ACCEPTED SOLUTION
v-lionel-msft
Community Support
Community Support

Hi,

 

Please do like this.

 

  1. Create a calculated column.

v-lionel-msft_0-1606703674106.png

  1. Create a measure.

 

Color =

VAR x = SUM('Table (2)'[Column])

RETURN

IF(

    x <> BLANK(),

    "#E66C37", "White"

)

 

 

  1. Create a matrix and set formats.

v-lionel-msft_1-1606703674108.png

v-lionel-msft_5-1606703984415.pngv-lionel-msft_6-1606703996178.png

Best regards,
Lionel Chen

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

 

 

View solution in original post

4 REPLIES 4
v-lionel-msft
Community Support
Community Support

Hi,

 

Please do like this.

 

  1. Create a calculated column.

v-lionel-msft_0-1606703674106.png

  1. Create a measure.

 

Color =

VAR x = SUM('Table (2)'[Column])

RETURN

IF(

    x <> BLANK(),

    "#E66C37", "White"

)

 

 

  1. Create a matrix and set formats.

v-lionel-msft_1-1606703674108.png

v-lionel-msft_5-1606703984415.pngv-lionel-msft_6-1606703996178.png

Best regards,
Lionel Chen

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

 

 

View solution in original post

amitchandak
Super User
Super User

@amalrio , Create a color measure

measure =countrows(Table)

color measure  = if(not(isblank(countrows(Table))) , "red", "white")

 

Add a measure to visual in conditional formatting color both background and font using conditional formatting - Field value option

 

refer step: https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Hi @amitchandak , 

 

My issue is I get to see below when I do that, I want to achieve my expected outcome, which is not duplicating the facility name. how would you go about it.

 

amalrio_0-1606358287347.png

 

@amitchandak , 

 

is that something you can achieve or not ??

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.