Forum Discussion

harshadrokade's avatar
harshadrokade
Post Partisan
5 years ago
Solved

Suitable visual help required

HI,

 

I have data as below. I want to know how can I show this kind of visual in power bi which is created in excel.

 

  • Data-
StudentScore AScore B
ABCLowMedium
XYZMediumLow

 

  • Visual created in excel which I want to create in Power bi-

 

 

Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi harshadrokade,

     

    Are your expected output as follows:

    You can try measure as:

    Measure = 
CALCULATE(
    CONCATENATEX('Table',MAX('Table'[Student]),","),
    FILTER(
        'Table',
        'Table'[Score A\ScoreB]=MAX('Table'[Score A\ScoreB]) && 'Table'[Score B]=MAX('Table'[Score B])
    )
)

    The pbix is attached.

    If I have not understood your needs correctly, please reply to me.

     

    Best Regards,
    Link

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

6 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey harshadrokade ,

     

    you can do something like that with a matrix:

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • harshadrokade's avatar
      harshadrokade
      Post Partisan
      5 years ago

      Hi Sir, Unable to bring Student names in mAtrix like you brought. Whe I add Student names in the Values field, I get same Student names, multiple times in all rows & Columns

  • harshadrokade's avatar
    harshadrokade
    Post Partisan
    5 years ago

    Actually the matrix visual not showing Score B header. The same thing you can observe in the image you shared. Also unable to understand What should I add in 'Row' field, What in 'Column' field & what in 'Values' field. Values field is confustion as it has Student names & no any numeric values.

    • selimovd's avatar
      selimovd
      Most Valuable Professional
      5 years ago

      Hey harshadrokade ,

       

      yes, the header is confusing. Maybe name it differently.

      The names I put because you asked for it. You can of course change it to numbers...

       

      Check that:

      And the settings for the Matrix:

       

      Would that work?

       

      Best regards

      Denis

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi harshadrokade,

     

    Are your expected output as follows:

    You can try measure as:

    Measure = 
CALCULATE(
    CONCATENATEX('Table',MAX('Table'[Student]),","),
    FILTER(
        'Table',
        'Table'[Score A\ScoreB]=MAX('Table'[Score A\ScoreB]) && 'Table'[Score B]=MAX('Table'[Score B])
    )
)

    The pbix is attached.

    If I have not understood your needs correctly, please reply to me.

     

    Best Regards,
    Link

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

    • harshadrokade's avatar
      harshadrokade
      Post Partisan
      5 years ago

      Thanks Sir. I shown the data in a card format & that was accepted by the boss. Thanks a lot for taking time out & helping me sir