Forum Discussion
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:
- Create a Matrix visual
- In the Matrix settings, go to the Paint Roller settings, and go to Values, and flip on the Show on Rows setting.
- 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
Community Champion
Hi deanbland ,
Try this:
- Create a Matrix visual
- In the Matrix settings, go to the Paint Roller settings, and go to Values, and flip on the Show on Rows setting.
- 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.