Business Intelligence Power BI
Conditional formatting text fields in Power BI using DAX
Conditional formatting is a Power BI feature used to change the color of values on visuals based on conditions or rules. Learn how to do it in this article.
.NET
Combining Excel files stored in a folder with Power BI
In this article, we’ll introduce two different approaches to easily combine Power BI Excel files stored in a folder on our local machine and present good practices.
Business Intelligence Power BI
Color the chart background according to target with Error Bars
It is common to compare actual values and targets to know if we are doing well or not. With Power BI, you can accomplish that in several different ways. For example, you can use conditional formatting in a table or a matrix to color the background or the font or add icons next to the data to quickly check if Read more…
Azure Business Intelligence
Extracting Data from a Data Lake through PowerShell, using a Databricks ODBC Connection
In today’s data-driven world, the ability to extract and analyze data from various sources is crucial. One common scenario is extracting data from a data lake, which serves as a centralized repository for raw and transformed data. In this blog post, we will explore how to use PowerShell to query Databricks tables through an ODBC connection to accomplish this task Read more…
Business Intelligence Power BI
Upgrade your Excel with Power BI – Part 1
Unlock the hidden potential of your data:
Revolutionize the way you analyze, visualize, and share your business insights.
Power BI
The greatness of Dynamic Format String is now in Power BI
namically change the formatting of data visualizations based on certain conditions or user interactions. It provides flexibility and enhances the interactivity of reports and dashboards, enabling users to customize the appearance of their data dynamically.
Business Intelligence Power BI
A Slice of Power BI: Dynamic Pie Chart Slices and Flexible Drill-Downs
In today’s data-driven world, effective data visualization is essential for transforming raw data into actionable insights. Microsoft’s Power BI has emerged as a leading business intelligence tool that enables users to create engaging and interactive visualizations. One of the most popular visualization types is the pie chart, known for its simplicity and ability to provide a quick understanding of the Read more…
Power Apps Power Platform
How to Import a Power App List form if the app already exists
You’ve probably already checked how to import a Power App to a new list. However, when you try to import it to a list form and that app already exists, it won’t be available to update and selecting new app will result in an error: One or more resources didn’t import. See the error details to resolve the issues, and Read more…
Office365 SharePoint
SharePoint MultiChoice with ‘Fill-in’ choices
Power Apps forms is an excellent tool to connect and customize SharePoint list forms, but when they include a MultiChoice Field, is only provided a combobox where its not possible to use the feature of ‘Fill-in’ choices of the field. When you add an edit-form, and connect it to the Sharepoint listPower Apps creates a combo-box for the multichoice field Read more…
Power Apps
Power Apps – Change Date Picker calendar colors
In Power Apps, it’s simple to change the controls’ appearance by changing properties like fill and color, but we can´t change the calendar’s appearance in the Date Picker control. Well, there is a way now 🙂 The process that we are about to show will allow you to change the calendar’s colors. This workaround consists of exporting the app and Read more…
