Tag visualisation
Types of scatterplot: Markers for conditional formatting: Clusters in scatterplot: Clusters for country: Hidden relation: Visual bar chart: Creating combined axis chart: Ribbon chart: Scale to fit: Small Multiples:
Practice: Current Year sales: Previous Year Sales: Formatting profitablity: Steps building Dashboard: 1.First adjust dashboard size as per your requirement2.Ensure Floating selected and drag vertical container, Go to Layout and adjust its x,y and Height and Width3.Click on Tiled, Add… Continue Reading →
Power Query Editor is a data transformation and cleansing available in power BI. Performing data transformations: Split the columns into seperate columns based on delimiter Unpivot columns: Unpivoted Columns: Replace Value: String data cleaning: Age calculation: Adding conditional column: By… Continue Reading →
Dashboard: Dax expression: Slicer:To exclude row by row in slicer France Sales = calculate(sum(Sales_data[Sales Amount]), ‘Sales Territory_data'[Country] = “France”, ALL(Sales_data)) Non_france aus sales = CALCULATE(SUM(‘Sales_data'[Sales Amount]), … Continue Reading →
Getting started: Load sample financial dataset: Transform data: Web scrapping for World Happiness Report: Previewing to Select data: Tagging geo location: Creating visual Map: GDP per capita in Bubble size: Creating hierarchy for countries: Power query editor: Create relation: Continent… Continue Reading →