Forum Discussion

deanbland's avatar
deanbland
Icon for Helper III rankHelper III
5 years ago
Solved

I need help producing a table

Hi, 

 

I am having trouble producing a table from the dataset I have. I am trying to produce the table in blue from the dataset, could someone please advise?

 

Thanks 

 

 

  • Hi deanbland ,

     

    Try this:

    1. Create a Matrix visual
    2. In the Matrix settings, go to the Paint Roller settings, and go to Values, and flip on the Show on Rows setting.

       

    3. Create three measures as shown below. Add all 3 measures to the VALUES section of the Matrix, and add the Stage field to the Columns

       

     

    Assignments Complated = 
    CALCULATE(
        COALESCE(COUNTROWS('Table'),0),
        'Table'[Assigments] = TRUE()
    )
    
    Gray Stuff = 
    CALCULATE(
        COALESCE(COUNTROWS('Table'),0),
        'Table'[Overall] = "Gray"
    )
    
    
    Reviews Completed = 
    CALCULATE(
        COALESCE(COUNTROWS('Table'),0),
        'Table'[Reviews] = TRUE()
    )

     

    It returns a visual like below.

     

    You need to make sure the TRUE/FALSE values are the TRUE/FALSE type. If they are the words "TRUE" and "FALSE" you need to change the measures above to say ="TRUE" and not =TRUE().

     

    You can turn off the totals in the Matrix using the Grand Totals feature. They are on by default which is why my visual has the bolded grand total column.

     

    If you need more help, please provide usable data for us to work with. We cannot use images as source data.

    How to get good help fast. Help us help you.
    How to Get Your Question Answered Quickly - Give us a good and concise explanation
    How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

1 Reply

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion

    Hi deanbland ,

     

    Try this:

    1. Create a Matrix visual
    2. In the Matrix settings, go to the Paint Roller settings, and go to Values, and flip on the Show on Rows setting.

       

    3. Create three measures as shown below. Add all 3 measures to the VALUES section of the Matrix, and add the Stage field to the Columns

       

     

    Assignments Complated = 
    CALCULATE(
        COALESCE(COUNTROWS('Table'),0),
        'Table'[Assigments] = TRUE()
    )
    
    Gray Stuff = 
    CALCULATE(
        COALESCE(COUNTROWS('Table'),0),
        'Table'[Overall] = "Gray"
    )
    
    
    Reviews Completed = 
    CALCULATE(
        COALESCE(COUNTROWS('Table'),0),
        'Table'[Reviews] = TRUE()
    )

     

    It returns a visual like below.

     

    You need to make sure the TRUE/FALSE values are the TRUE/FALSE type. If they are the words "TRUE" and "FALSE" you need to change the measures above to say ="TRUE" and not =TRUE().

     

    You can turn off the totals in the Matrix using the Grand Totals feature. They are on by default which is why my visual has the bolded grand total column.

     

    If you need more help, please provide usable data for us to work with. We cannot use images as source data.

    How to get good help fast. Help us help you.
    How to Get Your Question Answered Quickly - Give us a good and concise explanation
    How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.