Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
jbarta_mlchc
Helper II
Helper II

Conditional Formatting with String Fields May 2023 PBIRS

We just upgraded to the May 2023 release of PBIRS and I was hoping to take advantage of the new conditional formatting by string field. The data source for my report is a live connection to SSAS. Are there limitations on the use of the new string field function if you are using a live connection? Or maybe this feature is limited to certain visuals. I have attempted to do it in a table visual and under rules for the specified value the only options available are Count (Distinct) and Count. I expected to see First and Last other options in the Summarization drop-down box, but I do not see those:

 

jbarta_mlchc_0-1689175247978.png

Any help in understanding the limitations of this function would be greatly appreciated!

 

Update: Another thing I noticed in testing is that if I select Rule as the format Style and then go back to Gradient and then back to Rule again the If value is Text then rule shows up. But I still don't have an option for First and Last in the Summarization drop-down:

 

jbarta_mlchc_0-1689175794684.png

 

 

 

5 REPLIES 5
d_gosbell
Super User
Super User

No, my screenshot was from a live connection to SSAS 2019

Interesting. I wonder if it is a limitation due to my SSAS being 2016.

jbarta_mlchc
Helper II
Helper II

Update: Must not work with live connection. I imported my data and it worked, but when I have a live connection to my SSAS model it does not work:

jbarta_mlchc_0-1689202759057.png

 

 

d_gosbell
Super User
Super User

I'm not sure why that option is not appearing for you. I have the May 2023 version of Desktop for RS and I can see those options fine against a table visual

d_gosbell_0-1689200875861.png

 

Are you using live connection to your data source or import?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.