DATA ANALYSIS POSTING

Let's say you want a static value on your report's page while the page is being filtered by a slicer, The usual method is to turn off the interaction between the slicer and your value but what if you have two values on the same chart and you only want to filter one of them by the slicer?! Quite tricky isn't it? Well, the answer is really simple here's how: 1- Let's First Take A Look Of How The Error Looks Like This is obviously wrong! as the slicer affecting both the actual value and maximum value so they are giving the same read  we want to exclude the max measure so it can get the max of all time without affecting the actual daily read 2- The Answer Is Simple Let your measure be inside of a CALCULATE function that has ALL filter 3- Let's See The Result  I changed the day on the slicer couple of times to make sure and it seems about right 4- And Here Is The Case Of Both Values On The Same Chart Now you don't have to add them on two separate charts! The Slic...

Well this usually happens as you are hitting 'Combine & Transform' Letting Power BI doing all the work  well, Don't do this again! Have you ever got this annoying error when importing data from a folder on Power BI or Excel? Here's the best way to do it: 1- Click 'Transform Data' Instead Of 'Combine & Transform' This will let you do all the work from the start, don't be afraid it is so easy 2- Step By Step  1- That's our contents 2- We don't need the other information right now 3- Let's add a custom column 4- This is our magic word that will extract our data nice and good  5- That's our main column so rewove the others 6- Extract the sheets and tables within our excel files 7- That's an important note : you will have this if your data is in tables within your files  the editor reads it twice, once as a sheet and once as a table so you will have to only select one of them 8- Now after filtering to only tables we only want t...

It's a sneaky way to get around coding and using visual studio to create a link between a folder and SQL server but it is as efficient as it can be! The main idea is using Power BI's Query Editor to do all the boring work of merging data from multiple excel files for us into one table -also you can wrangle your data however you want- then exporting it using Dax Studio, So let's dig into it. 1- You Will Obviously Have To Download Dax Studio   It is a free 8MBs tool that can be easily downloaded from here:  DAX Studio - The ultimate client tool for working with DAX queries It's easy to install so I'm not gonna explain it to you, sorry. 2- Have A Look On The Data   So this is our data,  It's a folder containing multiple  excel files from which  we want to extract our data and merge it. It can be as many as it is  3- Open The Good Power BI And Get Data 1- Open Power BI 2- Click on 'get data' 3- Select data from 'folder' 4- Select your desired f...