cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vvelarde Super Contributor
Super Contributor

Re: How do I display a data grid in PowerBI

@DBirdmanAR

 

Yeah, is worked when have a Binary Scenario (accord to your original question and Data.)

 

Please post sample data with all the possible escenarios and will try to find a solution.

 

Regards

 

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Highlighted
DBirdmanAR Frequent Visitor
Frequent Visitor

Re: How do I display a data grid in PowerBI

Something like this: 

 

Notice that Patient C does not data for certain days and there is one Unk (Day 2 of Patient A).

 

 

= Table.FromRows({
    {
        "A","A1",
        1,
        1,
        "Pos",
        "https://cdn4.iconfinder.com/data/icons/keynote-and-powerpoint-icons/256/Plus-128.png"
    },
    {
        "A","A2",
        1,
        2,
        "Unk",
        ""
    },
    {
        "A","A3", 1,
        4,
        "Neg"  ,"https://cdn3.iconfinder.com/data/icons/softwaredemo/PNG/128x128/Minus_Circle_Green.png"
    },
    {
        "A","A4",
        1,
        6,
        "Pos",
        "https://cdn4.iconfinder.com/data/icons/keynote-and-powerpoint-icons/256/Plus-128.png"
    },
    {
        "A","A5",
        1,
        12,
        "Pos",
        "https://cdn4.iconfinder.com/data/icons/keynote-and-powerpoint-icons/256/Plus-128.png"
    },
    {
        "A","A6",
        1,
        24,
        "Pos","https://cdn4.iconfinder.com/data/icons/keynote-and-powerpoint-icons/256/Plus-128.png"
    },
    {
        "A","A7",
        1,
        48,
        "Neg" ,"https://cdn3.iconfinder.com/data/icons/softwaredemo/PNG/128x128/Minus_Circle_Green.png"
    },
    {
        "B","B1",
        2,
        1,
        "Neg" ,"https://cdn3.iconfinder.com/data/icons/softwaredemo/PNG/128x128/Minus_Circle_Green.png"
    },
    {
        "B","B2",
        2,
        2,
        "Pos" ,"https://cdn4.iconfinder.com/data/icons/keynote-and-powerpoint-icons/256/Plus-128.png"
    },
    {
        "B","B3",
        2,
        4,
        "Neg","https://cdn3.iconfinder.com/data/icons/softwaredemo/PNG/128x128/Minus_Circle_Green.png"
    },
    {
        "B","B4",
        2,
        6,
        "Neg","https://cdn3.iconfinder.com/data/icons/softwaredemo/PNG/128x128/Minus_Circle_Green.png"
    },
    {
        "B","B5",
        2,
        12,
        "Pos","https://cdn4.iconfinder.com/data/icons/keynote-and-powerpoint-icons/256/Plus-128.png"
    },
    {
        "B","B6",
        2,
        24,
        "Pos",
        "https://cdn4.iconfinder.com/data/icons/keynote-and-powerpoint-icons/256/Plus-128.png"
    },
    {
        "B","B7",
        2,
        48,
        "Pos",
        "https://cdn4.iconfinder.com/data/icons/keynote-and-powerpoint-icons/256/Plus-128.png"
    },
    {
        "B","B8",
        2,
        64,
        "Pos",
        "https://cdn4.iconfinder.com/data/icons/keynote-and-powerpoint-icons/256/Plus-128.png"
    },
    {
        "C","C1",
        3,
        1,
        "Neg" ,"https://cdn3.iconfinder.com/data/icons/softwaredemo/PNG/128x128/Minus_Circle_Green.png"
    },
    {
        "C","C2",
        3,
        2,
        "Pos" ,"https://cdn4.iconfinder.com/data/icons/keynote-and-powerpoint-icons/256/Plus-128.png"
    },
    {
        "C","C3",
        3,
        4,
        "Neg","https://cdn3.iconfinder.com/data/icons/softwaredemo/PNG/128x128/Minus_Circle_Green.png"
    },
    {
        "C","C4",
        3,
        6,
        "Neg","https://cdn3.iconfinder.com/data/icons/softwaredemo/PNG/128x128/Minus_Circle_Green.png"
    }
}, {
    "PatientID","PatientIDNumber",
    "YHelper",
    "StudyDay",
    "TestResults",
    "Image"
})

View solution in original post

Steve_Wheeler Established Member
Established Member

Re: How do I display a data grid in PowerBI

Though it has Known Limitations (see https://powerbi.microsoft.com/en-us/documentation/powerbi-service-r-visuals/#known-limitations), an R visual can do it.  See below for sample R script (12 lines without comments and blanks) and output.

 

library(ggplot2)    # Needed for ggplot
library(ggthemes)   # has a clean theme for ggplot2
library(tidyr)      # provide 'complete' function for empty heatmap cells

#Convert the (integer) StudyDay to a factor to avoid gaps in the X axis
dataset$StudyDay=with(dataset,factor(StudyDay))

#Fill missing data values, to avoid blank cells in the heatmap
dataset <- dataset %>% complete(PatientID, StudyDay)

# Avoid having to reference dataset$ each time in function calls
attach(dataset)

#Plot the dataset with TestResults to set the fill colour
ggplot(dataset, aes(x=StudyDay, y=PatientID, fill=TestResults)) +

#geom_tile to present as grid per https://www.rstudio.com/wp-content/uploads/2015/12/ggplot2-cheatsheet-2.0.pdf
  geom_tile(color="black", size=0.1) +

#Set the fill colours for TestResults
  scale_fill_manual(values = c("Pos" = "green", "Neg" = "red", "Unk" = "blue")) +

#Set square tiles
  coord_equal() +

#Apply tidy Tufte theme with no axis ticks
  theme_tufte(base_family="arial", ticks=FALSE) +

#Order by reverse PatientID
  scale_y_discrete(limits = rev(levels(PatientID))) 

DataGridInR.PNG

View solution in original post

Re: How do I display a data grid in PowerBI

Please share bi file for understnd how you have done it

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors