Slicer Visual with additional Information

[Kamaizziati]

Hi All,

I need your help regarding Slicer Custom Visual.

I uses Slicer Visualisation to filter data but can on slicer data shows others details.

Example

Figure 1 below show whe WBS Code and its Description. I want user slicer to filter the WBS code. Can on the WBScode selection (Figure 2 : Red rectangle highlight) at Slicer Visualisation comeout with the Description information.

Figure 1

 Figure 2

Thank You

[v-yuta-msft]

Hi Kamaizziati,

You can click Query Editor-> Transform-> Merge Columns as below:

 

After merged:

 

Then you can create a slicer based on the new column [WBSCode/Description].

Regards,

Jimmy Tao

[Kamaizziati]

Hi @v-yuta-msft,

Thank You for your reply.

I cant user merge because im in Direct Query mode.

DO you have any others way?

Thank You