AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Tabular editor power bi free download12/29/2023 ![]() Giving us the possibility to give feed back to the reader whether the temp is higher or lower than last year for instance. The label can also be controlled by an expression – Here you should especially notice that we now can control how blank values should be shown ️Īnd here telling the user that there is no data The values and label is formatted via the Callout section of the visual Tip – Notice that the color can be controlled by fx meaning that you could make the accent color change depending whether the temperature was higher or lower compared to last year.Īnother way of adding an accent bar is to use an image via the Fill propertiesĪnd then via the image control the location of your accent bar – the image is however static and can’t be controlled by a formula. Let’s start by adding an accent bar to the left Formatting optionsĮach of the measures you add to the visual can be formatted individually via the Cards properties In this post I will focus on how we can use the formatting options to make it really stand out. With the old card you would have to add a second Card to your report and sending two queries to your dataset instead of 1 as the new visual will do. When first added you might think … hmmm that is not really a big difference – BUT the BIG difference lies in your formatting options and that you can add more than one measure to the visual. The demo dataset is based on hourly temperature data from a weather station in central Copenhagen Denmark – shared via Danish Meteorological Institute – Open Data – DMI Open Data – Confluence (govcloud.dk) and the model imports data from their API for the period of until yesterday of the writing of this blog post. On social media you have probably already seen a lot of examples of usages, and I wanted to share how you can add a sparkline to the card to make it look something like this. Here is a link to the official blogpost – New card visual | Public preview | Microsoft Power BI Blog | Microsoft Power BI 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. #PowerQuery – Filter a table based on another table column or list – and some Filter aha’s.Specifying JSON Query in Power Query – Example Statistics Sweden.#PowerQuery - Replicate doing an Excel VLOOKUP in M.#PowerQuery – Create a date column from Year number and a month name.Set size for multiple visualizations in #PowerBI at the same time.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 ![]() ![]() 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. Here is a link How to try/test another #PowerBI theme on your existing reports in the service #PowerBI – Create a sparkline in the new card visual and some other nice formatting options ![]()
0 Comments
Read More
Leave a Reply. |