Skip to main content

Power BI Card Visual With Conditional Formatting

In this blog we will take you through the Power BI Card Visual and a workaround to present card with conditional formatting. To know more about what is Power BI please do check Power BI Blog. The conditional formatting, we do will not be on the Card Visual, but the output will certainly look like Card, which is a requirement in some cases. Many Power BI users have used Card Visual to represent some value on the Power BI Reports separately or on above of any other visual, but sometimes clients ask which is deemed difficult to achieve, but not impossible. So, let’s dive into the practical to know more about it.

Before, we proceed a small introduction to the Power BI Card Visual. Big Number Tile or Power BI Card Visual is used to represent a single important number or value which is an aggregated value or value generated from a measure.

Power BI Card Visual

The above picture shows a card having an Overall Avg value. So, this is how we can use Cards to show some important values in our reports. If we want to do some conditional formatting on a Power BI Card Visual, it is impossible to do so as there is no such option.

Now, we will show you some example through which we can make a look alike of a Power BI Card Visual having a functionality of conditional formatting using a Power BI Table Visual.

We have a sample data which has scores weekly wise, but we need to have data Monthly Wise, so we added Month Column and Month Num Column (For Sorting). Now, we have a visual which looks something like this which has a card showing the Overall Avg Score of ABC Month Wise.

Power BI Line Visual With Card

What if we would like to have a Card like visual showing the difference between current month and overall score like the shown below.

Power BI Card Visual With Conditional Formatting

So, let’s get started. First, we will create the two measures one for the Overall Avg and the other one Overall Avg Difference.  Select the Power BI Table Visual and add the measures created.

Power BI Table Visual
Then, we will switch to formatting tab and change the background color.

Power BI Table Conditional Formatting

Again, in formatting tab, we will select Field Formatting section and change the Background and Font colour and also enable Apply to header option as shown in pic below.

Power BI Table Visual Conditional Formatting

Rename the Overall Avg Difference measure with dot(.) and then go to field formatting tab again for the Overall Avg Difference column which is renamed to a Dot(.). Change the background color and enable the Apply to header option as well. Now our visual will look like this.

Power BI Table Visual Conditional Formatting

Click on the arrow on the column Dot(.) for conditional formatting and select the option Font Color.

Power BI Table Visual Conditional Formatting

In the Font Color page, select Format by as Rules, and add two rules as shown below and select colours for them.


Then select Icons under Conditional Formating


On the Icons page, create two rules as mentioned below and click Ok.


Under Formatting Tab, Grid selection, change the outline colour to the Background colour and your visual will look like this. Now we can change the size of the font and place it above our line visual.

So, after changing the font size and placing the Power BI Table Visual over Power BI Line Visual, the visual will look something like this and will give you a feel of Power BI Card Visual with Conditional Formatting.


I hope you like this blog which will give you a workaround how we can make a Power BI Card Visual with Conditional Formatting look alike using a Power BI Table Visual.

About Amlgo Labs : Amlgo Labs is an advanced data analytics and decision sciences company based out in Gurgaon and Bangalore, India. We help our clients in different areas of data solutions includes design/development of end to end solutions (Cloud, Big Data, UI/UX, Data Engineering, Advanced Analytics and Data Sciences) with a focus on improving businesses and providing insights to make intelligent data-driven decisions across verticals. We have another vertical of business that we call - Financial Regulatory Reporting for (MASAPRAHKMAEBAFEDRBI etc) all major regulators in the world and our team is specialized in commonly used regulatory tools across the globe (AxiomSL Controller ViewOneSumX DevelopmentMoody’s RiskIBM Open Pages etc).We build innovative concepts and then solutions to give an extra edge to the business outcomes and help to visualize and execute effective decision strategies. We are among top 10 Data Analytics Start-ups in India, 2019 and 2020.

Please feel free to comment or share your views and thoughts. You can always reach out to us by sending an email at info@amlgolabs.com or filling a contact form at the end of the page.

Comments

  1. I would like to thank the author for his useful and informative blog post about Power BI.

    Powerbi Read Rest

    ReplyDelete

Post a Comment

More Popular Posts

JavaScript: The Important Basics

In this weird world of technology people often get confused how does a website work? What all things should I be aware of? So we are here to help you. Most of the content on web is developed with the help of JavaScript. JavaScript is really becoming popular these days with the coming of ECMAScript2015 and ECMAScript 2016, for this reason, some beginners learning React and Angular and are also trying to tackle more modern JavaScript syntax at the same time. If you're new to both, it can be confusing as to "what is JavaScript and what are its important features". This document should serve as a primer to help you get up-to-speed on JavaScript syntax that we feel matters the most for learning React as well as Angular.

Amlgo Blog - Experience The Experiments

Amlgo Labs Blog  is a step towards our vision to share knowledge and experiences, Amlgoites accept every challenge very enthusiastically. We do experiments, we fail but we learn and build complex solutions to help our clients solve their problems in Data, Analytics, Prediction, Forecasting, Reporting, Designing and Development area. During this process we enjoy immense learning everyday and we have decided to share our thoughts, learnings, experiments and experiences so that we don't work in silos and contribute the best of our knowledge towards community and learn more by views and reviews. This website is maintained and brough to you by  Amlgo Labs Professionals .   Our Strong Basics -  1)   KISS (Keep It Simple and Straightforward) :  We believe most of the problems can be solved by keeping things simple and straight. This is the learning we had in past, sometimes we try to solve technical problems using high end algorithms and complex codes but this results into complications.

Power BI Blog - What is Power BI and Why we use Power BI.

This Power BI blog is an introduction to the Power BI. In this Power BI tutorial, you will learn Power BI basics - what is Power BI, Power BI Desktop and Power BI Service. Power BI tool is a combination of Business Intelligence and Visualization. Before we dig deep let’s understand what is Business Intelligence. Business Intelligence is a broad spectrum which consists of using different business strategies and techniques to gather data, refine it and process it for the purpose of data analysis which gives us some meaningful information which helps in data driven decision making. When we present this information in the form of some charts, graphs it takes the form of Visualization.

Polybase Blog - Introduction

Overview: This Polybase blog series is all about the use of Polybase Technology in today’s era to be able to take advantage of the Data(Relational and Non-Relational) by using T-SQL only. Data whether Big or not is the lifeline to many different sectors to cope up with Production, Maintenance, Predictions, Taking Precautionary Measures, Customer Satisfaction, Customer Retention, Sales, Revenue Generation and many more.

Polybase Installation for Scale-Out process

This part is the continuation of the previous blog about the introduction of  Polybase Scale-Out Group . As we have discussed in our earlier blog PolyBase enables your SQL Server instance to process Transact-SQL queries that read data from external data sources. SQL Server 2016 and higher can access external data in Hadoop and Azure Blob Storage. Starting in SQL Server 2019, PolyBase can be used to access external data in SQL Server, Oracle, Teradata, and MongoDB.

A simplified view of a QlikView tool:

In our last blog related to Qlikview, we discussed the use of Qlikview for Financial Data Analytics . Qlikview is a Business Intelligence tool that consists of a front end to visualize the processed data and a back end to provide the security and publication of the mechanism for QlikView user documents.

Stages of New Regulatory Reporting Implementation

In the last blog, we discussed what is  Financial Regulatory Reporting  and its importance in the banking industry. Regulatory Reporting comprises the submission of business numbers as required by regulators to evaluate and track the financial and operational status of financial institutions and their compliance with required regulatory provisions.