Using calculated columns in slicers buggy in PBI?

[joglidden2]

This is all in the same table... I created a calculated col that just concatenates two fields in the same table. Then I add that calc'd col to a slicer. So far, so good. Then, I can display "sliced" text from another field in the same table, for all records but one. There is nothing special about this record that won't display, that I can see with SSMS.

If I remove the calc'd col from the slicer, and replace it with another field, it works fine. Using a calc'd col in a slicer seems buggy in PBI desktop. Has anyone else had that experience?

[v-juanli-msft]

Hi @joglidden2

I can't reproduce your problem.

Could you show me how you create the calcualted column and which records doesn't work?

A screenshot of the error you meet is prefered.

Best Regards

Maggie

[joglidden2]

@v-juanli-msft, really appreciate the followup. I found a lame workaround for now. As soon as I get a few mins, I'll post more detail on what is happening. Here's the DAX calcd col formula:

Number_title = CONCATENATE(ASSESS_finding[Number], CONCATENATE(" ",ASSESS_finding[Title]))

And I'm using Hitachi HTML boxes to render the text. Everything is in one db table, in Azure sql server. 

[v-juanli-msft]

Hi @joglidden2

It is better to show a screenshot to explain :

Which value you select and what shows on the report?

For example, when i combine [cl1] and [cl2], then add [combine] in the slicer, 

when i select "11" in the slicer, the table shows value "a" in [cl3].

Then what error you meet? could you show me clearly?

cl1	cl2	cl3	combine
1	1	a	11
1	2	b	12
1	3	c	13
2	1	d	21
2	2	e	22
2	3	f	23

Best Regards

Maggie