Forum Discussion

pbiforum123's avatar
pbiforum123
Icon for Post Patron rankPost Patron
3 years ago
Solved

Comma separated value for same rank in table

We have created the table with Rank like below.     What Client is expecting is below. Instead of showing multiple rows for the same rank they want show only one row for the companies with s...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Thank you for your feedback, and please check the below picture and the attached pbix file whether it suits your requirement.

     

     

     

pbiforum123's avatar
pbiforum123
Icon for Post Patron rankPost Patron
3 years ago

Jihwan_Kim  Thanks a lot for your help! Yes we need this table in the visual not in the query editor.  In the visual they may have slicer like quarter, year, brand, etc...

 

Sorry if I did not explain the requirement cleary at first.

 

Any idea how this can be achieve in the visuals using the DAX?

 

Is it even achievable?

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Thank you for your feedback, and please check the below picture and the attached pbix file whether it suits your requirement.

 

 

 

  • pbiforum123's avatar
    pbiforum123
    Icon for Post Patron rankPost Patron
    3 years ago

    Jihwan_Kim Thanks a lot for this. Sure I will take a look tomorrow as I am little busy today.

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    I tried to write a comment in the measure like below.

    Please check the below picture and the attached pbix file.

     

     

  • pbiforum123's avatar
    pbiforum123
    Icon for Post Patron rankPost Patron
    3 years ago

    Jihwan_Kim Thank you so much, it is working perfectly. Could you please do me one favour? Whenever you are free could you please add the comments with your code explain how it works. Though it is working I am getting how it is working. So would like to understand that.