Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
@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:
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |