cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joglidden2 Frequent Visitor
Frequent Visitor

Using calculated columns in slicers buggy in PBI?

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?

3 REPLIES 3
Community Support Team
Community Support Team

Re: Using calculated columns in slicers buggy in PBI?

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 Frequent Visitor
Frequent Visitor

Re: Using calculated columns in slicers buggy in PBI?

@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. 
Community Support Team
Community Support Team

Re: Using calculated columns in slicers buggy in PBI?

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