Forum Discussion

Saxon10's avatar
Saxon10
Post Prodigy
5 years ago
Solved

POWER BI visualizations - multiple columns with different status in same report

  Hi,   I have one report that contain multiple columns (Status 1 to status 7) with different status (Okay, Not Okay, Completed and Not completed), each columns has different count with different ...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    5 years ago

    Hello @Saxon10 ,

    Is the second screenshot the result of your desire?

    If yes, we suggest that you create a new status table and seven measures. See the following steps.

    1. Create a table with Enter Data.

    Po1.jpg

    2. Create seven measures and place them in a table visual.

    STATUS1 Measure = 
CALCULATE(DISTINCTCOUNT(DATA[ITEM]),FILTER(DATA,DATA[STATUS1]=MAX('Table'[State])))+0

    Po2.jpg

    If you don't meet your requirements, could you show the exact expected result based on the table you shared?

    Best regards

    Community support team _ zhenbw

    If this post helps,then consider Accepting it as the solution to help other members find it faster.

    BTW, pbix as an attachment.

Saxon10's avatar
Saxon10
Post Prodigy
5 years ago

Hi. Thanks for your reply and suggestions. Those 7 status came from DAX function measure so unable to use the power query editor options. 

AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

Saxon10 Please share what the raw data looks like, this will help us provide you with the best suggestions. You've probably seen it already, but Greg's post here is very helpful: https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

If we don't know all the information, we can't give helpful responses. 

 

In addition to the raw data format of the tables, please share the DAX formulas you're using for the measures as well as any relationships between tables. 

 

Thanks!