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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
jbarta_mlchc
Helper III
Helper III

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 III
Helper III

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
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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