Forum Discussion

MYL_CIQ's avatar
MYL_CIQ
New Member
3 years ago

Small Multiples Title Delimiter for multiple data field

While using multiple data fileds in small multiples, comma is used as delimiter in small multiples title. Is there any option/ work around? Since my column value itself contains comma, Its difficult to differentiate between column!

Small multiple title appears like S&P 500, Supply Chain, Sustainability & Responsible Sourcing

 

Column1 value : S&P 500,

Column2 value: Supply Chain, Sustainability & Responsible Sourcing

Expectation: S&P500 : Supply Chain, Sustainability & Responsible Sourcing

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi MYL_CIQ ,

    After testing, it will default to adding ',' in the middle of the title when there are multiple fields with small multiples, and there is no option to modify the default characters.😣

     

    You may consider adding column="["&[columnname]&"]" in the Power Query Editor to distinguish the full title and the final result looks like this.

     

    It is recommended that you submit this idea here.

    Ideas

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data