When you sign in to the playground with your credentials and click “Select Report” under use my own Power BI report The Microsoft Power BI Embedded playground – Power BI Playground – gives us the option to try the developer sandbox The tool also has the excellent option of showing demo visuals to get a feeling of how it will look.īut I want to see how my new theme might look on some old report where I might have used another theme or perhaps some reports other users have created where they have done some individual formatting instead of using the theme.Īnd did you know – we can do it and see the result for existing report in your workspaces – and we can directly modify the theme and see if we should change a color or a font size or a…. So I use the excellent theme designer tool from powerbi.tips – Īnd I use the paid version so I can save my themes that I use for different clients. I am a big fan of using themes in Power BI but the current theme designer in Power BI desktop is very limited and doesn’t support all the things you really can do with themes. #PowerBI – Create a sparkline in the new card visual and some other nice formatting options. ![]() Specifying JSON Query in Power Query – Example Statistics Sweden. ![]() #PowerQuery – Filter a table based on another table column or list – and some Filter aha’s.#PowerQuery - Replicate doing an Excel VLOOKUP in M.#PowerQuery – Create a date column from Year number and a month name.Start by selecting both columns and under the Let’s imagine your data contains two columns with year and the month name and you want to create a date column. Here is another example that might help you. Sometimes it’s the little things that can help you minimize the number of steps in your Power Queries. Inspired by Darrens Gosbell’s excellent blog post – Automatically generating measure descriptions for Power BI and Analysis Services with ChatGPT and Tabular Editor – Random Procrastination () – and my session at SQLBits 2023 where I showed how to call the chatGPT from within Power Query and how you can use the New chat () #PowerQuery – Create a date column from Year number and a month name My first choice was to use a shape Document your #powerbi model with #chatGPT and a #tabulareditor script and browse it in your model Yesterday I worked on a Power BI report where the client wanted to add vertical bar next to the slicer in order to make the design of the slicers a little bit nicer and also to make the slicers recognizable cross pages by using the same coloring. So I use the excellent theme designer tool from powerbi.tips – And I use the paid version so I #PowerBI – Adding a vertical bar to your slicer ![]() Here is a link How to try/test another #PowerBI theme on your existing reports in the service In the June 23 release of Power BI desktop we has been blessed with a new card visual that not only will give a better performance compared to adding multiple cards in the past but it also gives us some formatting options we have been dreaming of for a long time. ![]() #PowerBI – Create a sparkline in the new card visual and some other nice formatting options
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |