Latest Power BI and AI articles from RADACAD team
Can you change the format of a measure or a value in Power BI dynamically? Is it possible to set a value to be a percentage sometimes, and sometimes to be a currency? can you change the currency format? The answer to all these questions is yes. In this short blog, I am going to Read more about Dynamically change the format of values in Power BI[…]
One of the great news in Microsoft Ignite 2020 is the announcement of a new licensing plan for Microsoft Power BI, called Premium Per User, or Premium Gen2. In this article, I’ll explain what that is, and how this can be helpful for Power BI users. Power BI Licensing To understand the Premium Per User Read more about What is Premium Per User License for Power BI, and What is it good for?[…]
Regarding using Charticulator for creating custom visuals, I come across one of the visuals in the Charticulator gallery and I decided to follow it up to see how it created. So I manage to create a dataset that has ranking, name and amount. https://charticulator.com/gallery/co2_emission_ranking.html In this example, I am using Carbon dioxide emission data for Read more about Ranking Chart in power BI Desktop Using Charticulator[…]
I was in the middle of data transforming to create a clean dataset for a Charticulator post, that I come across a dataset as http://mdgs.un.org/unsd/mdg/SeriesDetail.aspx?srid=749 This dataset is for Carbon dioxide emissions in different countries around the world. The only columns I need from this datasets is about country name and the number of emissions for Read more about Remove Columns with Specific Patterns Name in Power BI using Power Query[…]
Did it happen to you that you have calculated a cumulative total (such as running total, or year to date, etc) either using the quick measures or by writing the DAX expression yourself, and then realizing that the calculation happens even for the periods without any real data? For example, you want to stop that Read more about Stop DAX Cumulative Total Calculation in Power BI[…]
The news about Power BI external tools have gone viral on the internet, and every day we see many useful tools added under external tools. The good news for those of you who have been waiting is that you can now have Power BI Helper also (even though a bit late in the game) to Read more about Install Power BI Helper as an External Tool for Power BI[…]
Despite my many articles about the importance of star-schema and design principals of fact and dimension tables. I still get this question a lot: “When is good to combine tables vs loading them in the Power BI and creating a relationship between them?” This article is going to answer this question. Relationships In Power BI Read more about Combine Tables or Create Relationships? The Power BI Modeling Best Practice[…]
Power Query is often the engine used for combining data tables, especially using Merge or Append. However, sometimes, you might need to do that operation in DAX. An example of that is when you want to create that combination only virtually as part of a measure calculation that evaluates dynamically. In this article, I’ll explain Read more about Combining Tables in Power BI: Union, Except, and Intersect in DAX[…]
In the last two posts, I have explained what is Q&A visual and how we can define an adjective for each column. In this post, I will explain how to define a synonym for a column so if the business users use another word with the same meaning, still they able to use Q&A visual. Read more about Q&A Visual – Define a Synonym for a Column[…]
If you even need to show your DAX measures in a chart without a dimension to slice and dice it, you won’t get a great experience in the visual. In this blog post, I’ll share a trick that you can use to have a nice visualization like what you see in the above screenshot. How Read more about DAX Measure in the Axis of the Power BI Report[…]