Labeling a filter

[ppgandhi11]

Hi,

I have ProductID setup as a report level filter in my PowerBI report. However since they are ID it is hard to find what it means. I have ProductDesc field as well in the source. I would like to keep ProductID as filter but some mechanism to see what the corresponding description is.

One option could be: when we hover mouse on the ProductID, the associated description in the filter area would pop up.

Another option could be: the display label would be a concatenation of ProductID and Product Description (I don't know if we go this route, if the filtering would work properly in the powerBI report).

Third option could be to show ProductDescription with brackets showing productID next to it - something like: This is sample description (102)

second and third option looks similiar implementation wise, its just different flavor.

Any idea how to go about it? The first option looks very elegant.  Any tips is greatly appreciated. Thanks.

Prashant-

[Anonymous · Accepted solution]

@ppgandhi11,

I dont think the first option is possible within Power BI. For your second and third options, you could create a calculated column in your product table to concatenate product ID and Name using CONCATENATE in DAX: https://msdn.microsoft.com/en-us/query-bi/dax/concatenate-function-dax

[ppgandhi11]

Thanks @Anonymous

it works like a charm!