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.

v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
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

    thanks for your time. This is exactly I am looking for.

  • aherabit's avatar
    aherabit
    Helper I
    3 years ago

    This solution worked except for status values containing space characters. 

    In fact, it works on a small data sample but fails on large data feed.

     

    Any suggestions?