Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Microsoft Power BI Community
- Forums
- Get Help with Power BI
- DAX Commands and Tips
- How to show Total Sale value Bar chart or any visu...
Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Highlighted
Shahabh786
Frequent Visitor
How to show Total Sale value Bar chart or any visual in Power BI
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-13-2020
02:18 PM
Hi Folks,
Can anybody please help me in getting Total Sale in one bar in Bar Chart visual as show below in picture.
I have calculated total in dataset only just to show the example.
1 REPLY 1
Highlighted
Greg_Deckler
---------------------------------------
Putting square pegs in round holes since 1972.
I have a NEW book!
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!
Greg_Deckler
Super User IV
Re: How to show Total Sale value Bar chart or any visual in Power BI
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-13-2020
09:17 PM
Probably going to need to use the disconnected table trick. Here is an example:
Basically, create a separate, disconnected table for your x-axis categories. Craft a measure that looks at the MAX value of that column and then returns the correct summation/aggregation.
---------------------------------------
Putting square pegs in round holes since 1972.
I have a NEW book!
DAX Cookbook from Packt
Over 120 DAX Recipes!Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Helpful resources
Announcements
Super Users of the Quarter - Q2 2020
Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!
June 2020 Community Highlights
Featured community members, changes to the Community, and more! Read up on recent Power BI community news.
Community Summit North America
Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications
Power Platform 2020 release wave 2 plan
Features releasing from October 2020 through March 2021
-
DAX
538 -
Need Help
273 -
DAX Calculation
111 -
Measures
74 -
Filter
58 -
help
54 -
measure
47 -
Dax Help
47 -
DAX Query
41 -
CALCULATE
37 -
DAX filter formula
35 -
Power BI
29 -
COUNT
26 -
Help me please
24 -
Help Requested
22 -
Help required
22 -
Date
20 -
sum
18 -
POWER BI Dax rules
18 -
dax measure
17 -
RANKX
16 -
SUMMARIZE
15 -
Help me
15 -
Table
15 -
Filtering
15 -
Tips and Tricks
15 -
TopN
15 -
Time Intelligence
14 -
if
14 -
if statement
14 -
dates
14 -
average
13 -
Calculated columns
13 -
PowerBI Desktop
12 -
running total
12 -
dax functions
12 -
all
12 -
help needed
11 -
Slicer
11 -
Show and Tell
11 -
help in dax Function
11 -
DAX. CALCULATE
10 -
Formula
10 -
Filters
10 -
Matrix Visual
10 -
Power Query
9 -
values
9 -
DAX function
9 -
Help with DAX
9 -
Distinct
9 -
percentage
9 -
RLS
8 -
Desktop
8 -
Date and Time
8 -
YTD
8 -
Calculatetable
8 -
distinctcount
8 -
Conditional Formatting
8 -
Help with DAX Measure
8 -
matrix
7 -
DATEADD
7 -
LOOKUPVALUE
7 -
DATEDIFF
7 -
powerbi
7 -
sumx
7 -
DAX Direct Query
6 -
time functions
6 -
General
6 -
Urgent Help
6 -
ranking
6 -
hierarchy
6 -
Cumulative Sum
6 -
Measure Column Total
6 -
Filter context
6 -
Top N
6 -
ALLEXCEPT
6 -
averagex
6 -
Dynamic Date Period
6 -
Max
6 -
rank
6 -
Related Tables
6 -
calculated column
6 -
DAX RANKX
5 -
Power Pivot
5 -
Cumulative Totals
5 -
Compare
5 -
Power BI Dax
5 -
value
5 -
CountIfs
5 -
SELECTEDVALUE
5 -
Dax commands help
5 -
Data Modeling
5 -
measure based on slicer
5 -
Difference
5 -
groupby
5 -
columns
5 -
if condition
5 -
Urgent Help with DAX
5 -
Date measures to filter data.
5 -
crossjoin
5 -
index
5 -
total
5 -
calculated table
5 -
rolling 12
5 -
Tutorial Requests
4 -
cumulative
4 -
Virtual Table
4 -
tabular
4 -
Need Help - Goals
4 -
Switch()
4 -
DAX BUG
4 -
optimize
4 -
Get Help
4 -
VAR
4 -
USERELATIONSHIP
4 -
Distinct Counts
4 -
Year
4 -
Sumx()
4 -
average of a measure
4 -
group
4 -
join
4 -
Direct Query
4 -
Table Visual
4 -
Need Info
4 -
divide
4 -
isfiltered
4 -
dax mode count
3 -
Average Grand Total
3 -
Merge
3 -
SAME PERIOD LAST YEAR
3 -
DAX For Filter
3 -
tutorials
3 -
Waterfall Chart
3 -
COUNTROWS
3 -
Dax Join
3 -
multiple rows
3 -
MAXX
3 -
VLOOKUP
3 -
QTD
3 -
@needhelp
3 -
Totals
3 -
card
3 -
rows
3 -
SSAS
3 -
TOTALYTD
3 -
condition
3 -
date interval
3 -
Power BI Desktop
3 -
currency conversion
3 -
COUNTX
3 -
tables
3 -
Month
3 -
selected values
3 -
subtotals
3 -
Aggregation
3 -
averages
3 -
EARLIER
3 -
variables
3 -
weighted averages
3 -
lookup
3 -
Dynamic
3 -
Year over Year
3 -
SUM of Units
3 -
calculated rows
3 -
dynamic table
3 -
chart
3 -
DAX Time Intelligence
3 -
Row Level Security
2 -
Variable calculation
2 -
Line chart
2 -
Switch Metric
2 -
count distinct with condition
2 -
Direct Query mode
2 -
Filter based on context
2 -
datesbetween
2 -
Filter Multiple Column
2 -
query
2 -
calculated tables
2 -
SQL to DAX
2 -
dax tip
2 -
bar charts
2 -
drillthrough
2 -
KPI
2 -
duration
2 -
Slicer Visualizations
2 -
beginner
2 -
Composite Model
2 -
Calculations
2 -
Need Hepl
2 -
CUMULATIVE COUNT
2 -
SQL
2 -
what if parameters
2 -
Loop
2 -
M
2 -
Forecasting
2 -
percentile
2 -
Last Year
2 -
DAX for max utilisation
2 -
%
2 -
sumtotal
2 -
SVG
2 -
rolling dates
2 -
SSAS Tabular
2 -
New Challenge
2 -
Max date from select dates in Dataset
2 -
PowerBI Community
2 -
grand total
2 -
column calculation
2 -
grouping
2 -
Reporting
2 -
pareto
2 -
forecast
2 -
searching from 2 tables
2 -
cumulative percentage
2 -
In
2 -
date range
2 -
drill
2 -
DAX SWITCH
2 -
CONTAINS
2 -
calendar
2 -
CONCATENATEX
2 -
color
2 -
e
2 -
complex
2 -
addcolumn
2 -
All()
2 -
sumifs
2 -
i
2 -
unique
2 -
relatedtable
2 -
context filter
2 -
keepfilters
2 -
percentages
2 -
LASTNONBLANK
2 -
Text
2 -
date slicer
2 -
Analysis Service
2 -
dynamic filter
2 -
MTD
2 -
Events in progress
2 -
previous year
2 -
AND
2 -
Total wrong in matrix
2 -
Categories
2 -
cumulative value
2 -
Dax studio
2 -
bar chart
2 -
employee
2 -
Variances
2 -
Total Sum
2 -
cummulative
2 -
Format
2 -
time
2 -
timeline
2 -
context
2 -
switch
2 -
slicers
2 -
Formatting
2 -
min
2 -
Conversion
2 -
Data Modelling
2 -
relations
2 -
distribution
2 -
Count rows (date) by month
2 -
conditional
2 -
Performance Issues
2 -
concatenate
2 -
grouped
2 -
dates table
2 -
Cumulative Totals by category
2 -
Circular dependency
2 -
benchmark
2 -
aggregate
2 -
sorting
2 -
SUMMARIZECOLUMNS
2 -
Weekday
2 -
guidelines
2 -
Performance
2 -
Median
2 -
SUMIF
2 -
firstdate
2 -
Matrix Visualisation
2 -
Need help (Using direct query)
2 -
IF ELSE
2 -
multiple tables
2 -
FILTERS DAX KEEPFILTERS
2 -
cumulative sum by category
2 -
previous week
1 -
evaluation
1 -
What If
1 -
Urgent
1 -
scatterplot
1 -
Margin
1 -
graphs
1 -
Mean Time Between Failure
1 -
date ranges
1 -
timeline report
1 -
Power BI report builder
1 -
weighted distinct count
1 -
multiple date tables
1 -
M language
1 -
Replace Text Based on Another Column
1 -
Circle diagram
1 -
Line & Stacked Column
1 -
20
1 -
count of count
1 -
To Show Ratio 1:2
1 -
HR
1 -
Operator
1 -
relationships
1 -
mailto
1 -
General Comment
1 -
snapshot
1 -
analysis services
1 -
node
1 -
Regression
1 -
FX
1 -
running balance
1 -
Match
1 -
last date time refresh
1 -
spend
1 -
weekdays
1 -
Tableau
1 -
Lookupvalues
1 -
Object level security
1 -
Search table columns for similair data
1 -
DAX com
1 -
Error due to relationship
1 -
30
1 -
ee
1 -
ALLSELECT SURVIVAL RATE
1 -
Turnover
1 -
Custom Filter
1 -
DAX Hierarchy
1 -
pivot table
1 -
subject line
1 -
Data model
1 -
key
1 -
numbers
1 -
gauges
1 -
Hierarchy slicer
1 -
Exchange
1 -
minx
1 -
column selection
1 -
budget
1 -
Summary
1 -
OR function
1 -
bad data
1 -
fill empy cell
1 -
INCORRECT CALENDAR
1 -
XLOOKUP
1 -
PowerBI Help
1 -
40
1 -
tooltip
1 -
"Calculation Group"
1 -
have
1 -
cumulative sum by multiple criteria
1 -
Past & Current Month Latest data
1 -
commands
1 -
@Ranks with Trend
1 -
kpis
1 -
How To
1 -
finance
1 -
Duplicate data
1 -
PBI Desktop
1 -
Quarter
1 -
power bi visuals
1 -
while
1 -
negative
1 -
tutorial request
1 -
product function
1 -
Currency
1 -
sql_to_dax
1 -
one row
1 -
total zero
1 -
mailchimp
1 -
Cound IDs
1 -
Rolling Months
1 -
Need to mark holidays in calendar
1 -
variance
1 -
subtotal
1 -
Work days
1 -
50
1 -
expand
1 -
Help to update datasource
1 -
Find multiple values
1 -
utilization
1 -
Productivity
1 -
remote computers
1 -
Top5 and Bottom 5
1 -
have a
1 -
outbound delivery
1 -
update
1 -
Pricing
1 -
Subscription
1 -
date format
1 -
Region
1 -
CSV
1 -
Calc column assistance
1 -
ALLCROSSFILTERED
1 -
two tables
1 -
changing classifications
1 -
SPC DAX XMR chart Control limits
1 -
correct visuals
1 -
Roleplaying
1 -
tricks and tips
1 -
New Table creation
1 -
Match calculated ranking column
1 -
Dynamic Flag
1 -
holidays
1 -
result
1 -
custom sorting
1 -
Technical question
1 -
Week time intelligence
1 -
Lowest Market Share
1 -
available
1 -
Moving average for measures
1 -
Rankx with filter
1 -
not display data
1 -
Questions
1 -
Gantt chart
1 -
Visualisations
1 -
Visuals
1 -
metrics
1 -
selection
1 -
Power BI Help
1 -
loop up values from 2 tables
1 -
Expertise help
1 -
Slicer based on calculated Measure
1 -
by
1 -
variable
1 -
Append measure to table
1 -
"average"
1 -
salary
1 -
Dimension
1 -
new measure of % by group
1 -
custom formula
1 -
unpivot
1 -
Standard Deviation
1 -
Row Average
1 -
Column Chart
1 -
show statusRDP
1 -
Performance issues with AverageX
1 -
RankX excluding Some Values
1 -
Tips
1 -
Education
1 -
Query String
1 -
Streaming Datasets
1 -
Icons
1 -
POWER BI DATA VİEW
1 -
metric
1 -
conditions
1 -
comparison
1 -
count 0 and 1
1 -
ID
1 -
status change
1 -
delete rows
1 -
Summerizecolumn
1 -
incorrect total
1 -
CD and CSD
1 -
Test as a Role
1 -
Analysis Server
1 -
Measures to filter out
1 -
scenario
1 -
remote desktop connection
1 -
Alternatives for AverageX
1 -
Month on Month Rank Comparison
1 -
Google Analytics
1 -
data
1 -
Scheduled data refresh
1 -
New Help
1 -
Visualizations
1 -
TOTALYTD through Today
1 -
Unhandled
1 -
Counter
1 -
side by side
1 -
evaluate total for a period for a specific column
1 -
stage change
1 -
include
1 -
Search
1 -
&&
1 -
add value from prior row measure
1 -
previousmonth
1 -
EARLIEST
1 -
Market Share
1 -
Rebasing
1 -
Substract with a measure
1 -
return
1 -
BusinessCentral COA Totalling
1 -
dynamic percentage calculation
1 -
totals calculation not correct in matrix
1 -
Integer
1 -
date slicers
1 -
stacked bar
1 -
Azure Analysis services tabular model
1 -
Like for like pricing analysis
1 -
Floriankx
1 -
pie chart tree
1 -
last quarter
1 -
ThreeYear Average
1 -
Absolute Value
1 -
opportunity stage
1 -
Cummulative Prev Change
1 -
Summarize()
1 -
Replace Values Based on Another Column
1 -
Many to Many Relatioinship
1 -
Please save me
1 -
Multiplication and wrong total in table
1 -
filter direction
1 -
reference text
1 -
Total not matching
1 -
DAX Performace
1 -
Dinamic rows
1 -
Approximate Lookup Dates
1 -
Calculate function with multiple criteria
1 -
grand total row incorrect
1 -
survey
1 -
R
1 -
Scorecard
1 -
Visualization
1 -
column total
1 -
many to many relationship issue
1 -
kcantor
1 -
where
1 -
automatic
1 -
Grouped field
1 -
Icon Formatting
1 -
LLY
1 -
one inn many
1 -
not equal to
1 -
"aggregations"
1 -
simple
1 -
title
1 -
I'm losing my mind
1 -
Ignore Slicers
1 -
facts filtering dimensions
1 -
Unique Value
1 -
Optimizing DAX
1 -
column percent
1 -
growth rate
1 -
basket analysis
1 -
heed help on dax functions
1 -
calculation groups
1 -
Excel
1 -
correlation
1 -
live dashboards
1 -
parameter
1 -
Active Directory
1 -
change
1 -
iamprajot
1 -
New customers
1 -
Multiplying by Sum
1 -
FIFO
1 -
BI Vs Tableau
1 -
empty columns
1 -
profit and loss
1 -
hasonevalue
1 -
INACTIVE RELATIONSHIP
1 -
Custom calendar
1 -
calculate Percentile
1 -
Atingir Meta e Solver
1 -
file name
1 -
CODE
1 -
sclicer
1 -
subtract filtered value
1 -
consecutive loss
1 -
Backlog
1 -
DAX CALENDARAUTO()
1 -
Last
1 -
Embed
1 -
Visual
1 -
weekly-averages
1 -
ovetteabejuela
1 -
Forex
1 -
inner join
1 -
Measure Multiplication
1 -
Previous month
1 -
Advanced Visualization
1 -
Stock Valuation
1 -
churn
1 -
subgroups
1 -
suggestions on Data Analysis
1 -
ORDER
1 -
credit
1 -
F
1 -
in chosen periods
1 -
Ordered Vs Delivered
1 -
usage metrics report
1 -
veryon
1 -
aaa
1 -
SUM of MAX
1 -
Tip & Tricks
1 -
ab
1 -
help with date
1 -
Decomposition Tree
1 -
DAX Commands
1 -
opening balance
1 -
Azure
1 -
Embed Report
1 -
Scheduling
1 -
refresh data
1 -
running-totals
1 -
v-qiuyu-msft
1 -
needhelp
1 -
Company Average
1 -
Capital Gain
1 -
previous
1 -
Retention
1 -
change variables
1 -
pre
1 -
debit
1 -
dataype
1 -
yield
1 -
Bundle
1 -
DAX for deals added and slipped
1 -
COVID-19
1 -
Text Measure
1 -
fiscal period
1 -
Filter two tables
1 -
resource utilzation
1 -
Userrelationship
1 -
ALLSELECTED
1 -
stacked column chart
1 -
General Question
1 -
su
1 -
Interesting Links
1 -
Query Editor
1 -
queries
1 -
Visual Filtering
1 -
Maximum number of values
1 -
timeline slicer
1 -
quetsion
1 -
imported
1 -
normalize
1 -
row_number
1 -
Analysis
1 -
.DAX
1 -
Share Valuation
1 -
" cumulatives"
1 -
dashboard dax help
1 -
exclude
1 -
maximum
1 -
Production
1 -
financial report
1 -
Help with DATESYTD DAX
1 -
transitive closure
1 -
TopN by Store
1 -
Rolling 12 Months
1 -
function
1 -
Selections
1 -
Nominator
1 -
conditional columns
1 -
resets if 0
1 -
Year to date
1 -
able
1 -
s
1 -
TopN Customer
1 -
mdx
1 -
M Query
1 -
to
1 -
Combo Chart Report Server
1 -
Sum on a dynamic date range
1 -
Assigning Roles
1 -
Age
1 -
MAX date
1 -
Stock In Hand
1 -
Transaction
1 -
numbertostring
1 -
Nonlinear Regression
1 -
Null
1 -
selected value
1 -
ONE TABLE MODEL
1 -
select all
1 -
fortnight
1 -
Dynamic data selection based on date
1 -
WEEKNUM
1 -
Comcatenation
1 -
Likert scale
1 -
Denominator
1 -
semi-additive
1 -
Data Type
1 -
Average Sales
1 -
Previous Month Last Year Card
1 -
community
1 -
Report
1 -
BUG
1 -
default
1 -
counts
1 -
sharepoint online
1 -
combine
1 -
IFNA excel funation alternative
1 -
levels
1 -
Field Value
1 -
Managing Roles
1 -
% complete
1 -
Cumulative sum partition
1 -
active customers
1 -
MoM
1 -
DATESYTD Help needed
1 -
REMOVEFILTERS
1 -
like to get
1 -
Group total
1 -
10
1 -
I need t
1 -
Day of Week
1 -
Pareto Chart and table by Period help
1 -
Type
1 -
dyanmic
1 -
DAX Commands and Tips
1
Top Solution Authors
| User | Count |
|---|---|
| 47 | |
| 29 | |
| 22 | |
| 16 | |
| 16 |
Top Kudoed Authors
| User | Count |
|---|---|
| 60 | |
| 43 | |
| 31 | |
| 26 | |
| 22 |
Users online (2,609)
