Forum Discussion

krishna0's avatar
krishna0
Helper II
4 years ago

Report Builder: Custom Legend Text

Hello, folks.

 

I'm sorry if this is the wrong forum, but I can't find anything related to Report Builder so as well I might try here.

I have a paginated report in PBI Report Builder, it's working quite nice, but..

 

I have the legend created out of the answers given and currently it looks like this:

The thing I am missing is that, there are five answers possible, but the fifth ("Not applicable") was not chosen once, yet I need it to display anyway.

My original dataset does not contain this answer related to question (because it was not answered), so I created second dataset with the combination of all questions and answers and they have a key between them.

I managed to retrieve an array with all the answers assigned to this questions with the expression "=Join(LookupSet(Fields!QuestionIndex.Value,Fields!QuestionNr.Value,Fields!text.Value, "DataSet2"), ", ")"

So you see that the answer is there. I am just struggling with splitting it in a way that all elements of an array are shown, regardless of the answers given.

 

Anyone is able to support in any way?

 

Best regards

 

 

Need Help

2 Replies

  • krishna0's avatar
    krishna0
    Helper II
    4 years ago

    Anyone with some knowledge about this tool? I would appreciate any help on this matter..

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi krishna0 ,

     

    This seems impossible to achieve. The number of color icons is four and there is no place to show the fifth "not applicable". And the number of legends depends on the original dataset. You can try to modify the dataset.
    Or you can submit your idea to power bi ideas web site.

    Best Regards

    Community Support Team _ chenwu zhu

     

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