Dynamic ribbon content based on your view - In the old ribbon for Power BI Desktop, icons or commands that weren't available were grayed out, creating a less-than-optimal experience. In this model, you could do any modeling in the power bi, since ssas is acomplete data model, all the modeling must be done in ssas, you could only create a report level measure in power bi and do formatting for this measure. Use the ribbon in Power BI Desktop - Power BI | Microsoft Learn Find out more about the April 2023 update. Thanks , that worked for me but when i click on Sort by column i get nothing, Same here, after following those steps, the Sort by Column dropdown was no longer greyed out but clicking on it doesn't seem to do anything. Curious what a Super User is? Click on the column that may have a sort on it. Learn how to combine numerical transformations on multiple columns into a single step in Power Query.Check out my full courses and ebooks here: https://www.howtoexcel.org/courses/DOWNLOAD any example workbooks here: https://www.howtoexcel.org/downloads/SUBSCRIBE \u0026 get my 3 FREE eBooks. https://www.howtoexcel.org/newsletter/CONNECT with me on social:Facebook: https://www.facebook.com/howtoexcelblogTwitter: https://twitter.com/howtoexcelblogLinkedIn: https://www.linkedin.com/in/john-macdougall/Thanks for all your support! RobElliott In the first quarter of 2020, the updated ribbon will transition from being a preview feature to be the default ribbon you see in Power BI Desktop. 365-Assist* Power Platform Conference 2023 Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. AhmedSalih Solved: View - Filter By Choice, Greyed Out - Power Platform Community You can get around this by creating a measure that points to that measure you are trying to format. phipps0218 Obviously I am missing something, any idea what? I am trying to format a number value as currency by selecting the table field on the right hand side and using the formatting options in the 'column tools' tab but all formatting options are greyed out? Our community members have learned some excellent tips and have keen insights on building Power Apps. dpoggemann You are now a part of a vibrant group of peers and industry experts who are here to network, share knowledge, and even have a little fun! Super User Season 2 | Contributions January 1, 2023 June 30, 2023 28:01 Outro & Bloopers The updated ribbon displays themes in a gallery so you can more easily see what colors will be applied to your report. Alternatively, you could format the sorting month column to text and filter like so: There's a cleaner way to do this. Expiscornovus* Power Automate: The file menu has a modern look. All available features in the column tools options DirectQuery for Power BI datasets and Azure Analysis Services.