by Ehsan Adl | Nov 11, 2024 | Ehsan Adl
In Power BI, understanding when to use a measure and when to create a new column can impact performance, flexibility, and how data is displayed. Here’s a detail of the differences, with their advantages, disadvantages, and guidance on usage. Definition and...
by Ehsan Adl | Nov 10, 2024 | Ehsan Adl
If you want to know how to publish your Power BI dashboard into Novypro.com follow me:) 1. First, you need to Publish your report (dashboard) in the Power BI service. So, click on the Publish logo and then Publish it into your workspace. 2. Then, you can see the...
by Ehsan Adl | Nov 10, 2024 | Ehsan Adl
Hello everyone, If you want to create a dynamic title Power BI, follow these steps: Using Sample Superstore dataset, 1. Create a measure and give it a name for example “Dynamic Title”: Dynamic Title = SELECTEDVALUE(Orders[Sub-Category],”All...
by Ehsan Adl | Nov 10, 2024 | Ehsan Adl
Hello everyone, For example, In Sample Superstore, If you want to show both Top and Bottom 10 Customers, you should create a combined set: 1. Create Top 10 Customers set (by Sales): Right click on the Customer Name, Hover on the Create and then select...
by Ehsan Adl | Nov 10, 2024 | Ehsan Adl
Hello everyone, in this post I want to explain how to add dynamic reference lines into our Pareto Chart. If you want to see how to create a Pareto Chart use the following link: Visualizing the Pareto Principle in Tableau And, If you want to know the concept of Pareto...
by Ehsan Adl | Nov 10, 2024 | Ehsan Adl
In Sample Superstore: Put Sum of Sales in the Rows and Count Distinct of Product Name in the Columns. Put Product Name to Detail (in Mark section). Right click on SUM(Sales), Quick Table Calculation, choosing Running Total. Right click on CNTD(Product Name), select...
