DORSETRIGS
Home

powerbi-desktop (107 post)


posts by category not found!

How to get multiple category lines with bar chart in Power Bi?

Power BI Displaying Multiple Categories in a Bar Chart with Clarity Visualizing data in Power BI is powerful but sometimes you need to show the breakdown of dat

2 min read 06-10-2024 42
How to get multiple category lines with bar chart in Power Bi?
How to get multiple category lines with bar chart in Power Bi?

Can we remove vertical scroll from power BI table?

Banishing Vertical Scroll How to Fix Power BI Table Overflow Power BI tables are a powerful tool for presenting data but sometimes their flexibility can lead to

2 min read 05-10-2024 39
Can we remove vertical scroll from power BI table?
Can we remove vertical scroll from power BI table?

Is there any REST API to refresh specific table in a Power BI Dataset?

Power BI Dataset Refresh Can REST APIs Do the Trick The Problem Power BI users often face the need to refresh specific tables within their datasets especially w

2 min read 05-10-2024 37
Is there any REST API to refresh specific table in a Power BI Dataset?
Is there any REST API to refresh specific table in a Power BI Dataset?

Power BI :: Do I need a Gateway Connection when importing data from a web page?

Power BI and Web Data Do You Really Need a Gateway Power BI is a powerful tool for data visualization and analysis but connecting to external data sources can s

2 min read 05-10-2024 41
Power BI :: Do I need a Gateway Connection when importing data from a web page?
Power BI :: Do I need a Gateway Connection when importing data from a web page?

Add a new column from value that is stored in a list of cell of the table

Adding a New Column from a List of Values in a Table Problem You have a table with data and want to add a new column based on a list of values This list is stor

less than a minute read 05-10-2024 37
Add a new column from value that is stored in a list of cell of the table
Add a new column from value that is stored in a list of cell of the table

Creating a Music Podium top 5 - like visualization in Power BI from a table

Power BI Visualization Building a Dynamic Music Podium Top 5 Ever wondered how to visually represent your music chart data in a dynamic and engaging way With Po

2 min read 05-10-2024 53
Creating a Music Podium top 5 - like visualization in Power BI from a table
Creating a Music Podium top 5 - like visualization in Power BI from a table

Whitelisting URLs required for pbiviz

Unlocking Your Power BI Visualizations Whitelisting URLs for pbiviz Power BI visuals are powerful tools that bring data to life But sometimes they need a little

2 min read 05-10-2024 44
Whitelisting URLs required for pbiviz
Whitelisting URLs required for pbiviz

Using DAX in PowerBi to change data format from wide to long

Transforming Your Data Power BI DAX for Wide to Long Reshaping In data analysis you often encounter datasets with data arranged in a wide format where each row

2 min read 05-10-2024 43
Using DAX in PowerBi to change data format from wide to long
Using DAX in PowerBi to change data format from wide to long

How to format date in Powerautomate when Email to .CSV

Formatting Dates in Power Automate for Email to CSV Conversions Power Automate is a powerful tool for automating tasks including handling data and converting em

2 min read 04-10-2024 43
How to format date in Powerautomate when Email to .CSV
How to format date in Powerautomate when Email to .CSV

Power BI :: No conditional formatting on the bar color

Power BI Frustration Why My Bar Chart Colors Wont Change Based on Values Have you ever struggled to get your Power BI bar chart to visually represent data chang

2 min read 04-10-2024 49
Power BI :: No conditional formatting on the bar color
Power BI :: No conditional formatting on the bar color

Identify grouped rows based on multiple conditions using PowerQuery

Grouping Power Query Rows A Guide to Efficient Data Analysis Power Query is a powerful tool within Excel and other Microsoft products that simplifies data manip

2 min read 04-10-2024 41
Identify grouped rows based on multiple conditions using PowerQuery
Identify grouped rows based on multiple conditions using PowerQuery

custom column based on the length

Crafting Custom Columns Based on Length A Simple Yet Powerful Technique Often we encounter scenarios where we need to categorize data based on the length of a p

2 min read 04-10-2024 40
custom column based on the length
custom column based on the length

On selection of a product from a product vs sales bar chart, I want to see top 3 user comments about that particular product

How to Display Top User Comments on a Product from a Bar Chart When analyzing product performance through a sales bar chart its beneficial to understand user fe

2 min read 30-09-2024 41
On selection of a product from a product vs sales bar chart, I want to see top 3 user comments about that particular product
On selection of a product from a product vs sales bar chart, I want to see top 3 user comments about that particular product

How to use DAX to filter rows based on a date slicer

How to Use DAX to Filter Rows Based on a Date Slicer in Power BI When working with data in Power BI the need to filter rows based on specific criteria is crucia

2 min read 30-09-2024 67
How to use DAX to filter rows based on a date slicer
How to use DAX to filter rows based on a date slicer

Only show Last X days based on date slicer selection

How to Display Only the Last X Days Based on a Date Slicer Selection in Power BI In business intelligence tools like Power BI the ability to manipulate and filt

2 min read 29-09-2024 51
Only show Last X days based on date slicer selection
Only show Last X days based on date slicer selection

Calculated table from 2 tables and sum DAX

Understanding DAX Creating a Calculated Table from Two Tables and Summing Values In the realm of data analysis and reporting particularly when working with Powe

2 min read 29-09-2024 50
Calculated table from 2 tables and sum DAX
Calculated table from 2 tables and sum DAX

PowerBI: json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

Understanding Power BI Resolving the json decoder JSON Decode Error If you re working with Power BI and encounter the error message json decoder JSON Decode Err

2 min read 27-09-2024 53
PowerBI: json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)
PowerBI: json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

How to change Power BI default navigation as a cascading page navigation?

How to Change Power BI Default Navigation to Cascading Page Navigation Power BI is a powerful tool for data analysis and visualization allowing users to create

3 min read 27-09-2024 48
How to change Power BI default navigation as a cascading page navigation?
How to change Power BI default navigation as a cascading page navigation?

How to show timeseries data up to selected month in Power BI line chart with a Slicer

How to Show Time Series Data Up to Selected Month in Power BI Line Chart with a Slicer Power BI is a powerful business intelligence tool that allows users to vi

3 min read 24-09-2024 51
How to show timeseries data up to selected month in Power BI line chart with a Slicer
How to show timeseries data up to selected month in Power BI line chart with a Slicer

How to remove date hierarchy from model in Power BI

How to Remove Date Hierarchy from Model in Power BI When working with Power BI you may find that the automatic date hierarchy feature sometimes complicates your

2 min read 24-09-2024 48
How to remove date hierarchy from model in Power BI
How to remove date hierarchy from model in Power BI

Power BI file size not making sense

Understanding Power BI File Size Why It Might Not Make Sense Power BI is a powerful business analytics service that provides interactive visualizations and busi

3 min read 23-09-2024 45
Power BI file size not making sense
Power BI file size not making sense

Is there a way to automatically remove the "Sum of" of all data fields in Powerbi?

Automatically Removing Sum of from Data Fields in Power BI In Power BI when you add a measure or a field to a visual you often see labels like Sum of Field Name

2 min read 23-09-2024 59
Is there a way to automatically remove the "Sum of" of all data fields in Powerbi?
Is there a way to automatically remove the "Sum of" of all data fields in Powerbi?

Hide Levels From Hierarch - Power BI

Hiding Levels from Hierarchy in Power BI A Comprehensive Guide In the world of data visualization organizing your information effectively is key to helping your

2 min read 22-09-2024 71
Hide Levels From Hierarch - Power BI
Hide Levels From Hierarch - Power BI

Power Query SQL - Slicer values displays as text instead of Date data type

Power Query SQL Slicer Values Display as Text Instead of Date Data Type When working with Power Query in SQL you may encounter a common problem where the slicer

3 min read 22-09-2024 45
Power Query SQL - Slicer values displays as text instead of Date data type
Power Query SQL - Slicer values displays as text instead of Date data type

Power BI, simultaneous use of averages and filters

Power BI Using Averages and Filters Simultaneously for Insightful Data Analysis Power BI is a powerful data visualization and business intelligence tool that al

2 min read 21-09-2024 47
Power BI, simultaneous use of averages and filters
Power BI, simultaneous use of averages and filters