Tag Archives: PowerBI
Copying Data From A Table/Matrix in Power BI : September 2018 Update
Introduction The September 2018 Update of Power BI has finally brought to users, the functionality to copy data from a table or matrix in a report. This has been a much-requested feature as one often finds themselves needing to copy a value or columns of data from a report with no option to do so. … Continue reading Copying Data From A Table/Matrix in Power BI : September 2018 Update
Power BI September 2018 Update: Drillthrough To Another Report Page
The September update of Power BI features an important functionality: the option to drillthough to another page in that report. For example, if a user wants to see detailed data of a product ‘Product 2’, then they can right-click on Product 2 in the main report, select ‘Drillthrough’ and the relevant sub-report to have it … Continue reading Power BI September 2018 Update: Drillthrough To Another Report Page
Conditional Formatting By Values in Power BI: August Update
In the August 2018 update of Power BI, we can now apply conditional formatting based on field value. This allows us to use a measure or column that contains a color name, a hex name/code and apply that color to the background of the cells and the font in the cells of that column. For … Continue reading Conditional Formatting By Values in Power BI: August Update
PowerBI April 2018 Update: Combo Chart Line Formatting
Introduction: PowerBI introduced the feature to format line styles and legends for line charts a while ago. However, these features were not applicable to lines in combination charts like ‘Line and Stacked Column Chart’ and ‘Line and Clustered Column Chart’. With the April update of PowerBI Desktop, we are now able to customise the format … Continue reading PowerBI April 2018 Update: Combo Chart Line Formatting
Top-N Questions & Answers in Power BI
Introduction: With the latest update of Power BI, you can now ask top-n type questions and get answers based on your dataset. Questions like ‘What are the top 3 products by sales?’ or ‘Top Manufacturer by country’ are examples. This is also valid for bottom-n type questions like ‘Least selling product in a country’. Steps: … Continue reading Top-N Questions & Answers in Power BI