Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I am creating a line chart in Power BI, with 'month name', 'Company' and 'No of transcations' fields.
1) 'Month name' - it should show all the months for selected year.
( Ex: if it is '2021' it should be 'Jan to Aug (current month), if it is '2020', it should be 'Jan to Dec').
2) Company - It shows all the companies names. Company names may increase or decrease each year.
3) 'No of transcations' - It shows the number of transactions happend for each company for each year and month.
I need a measure for line chart, and it should divide 100% to all companies for each month. If you are confused with my words, please look at the attached screenshot.
Please help on this.
Thanks in advance.
Solved! Go to Solution.
Hi @venkataramana ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want.
% measure =
VAR _inditrans =
SUM ( 'Transactions'[No of transactions] )
VAR _permonthtrans =
CALCULATE (
SUM ( 'Transactions'[No of transactions] ),
FILTER (
ALLSELECTED ( 'Transactions' ),
'Transactions'[Date] = SELECTEDVALUE ( 'Transactions'[Date] )
)
)
RETURN
DIVIDE ( _inditrans, _permonthtrans, 0 )
Best Regards
Hi @venkataramana ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want.
% measure =
VAR _inditrans =
SUM ( 'Transactions'[No of transactions] )
VAR _permonthtrans =
CALCULATE (
SUM ( 'Transactions'[No of transactions] ),
FILTER (
ALLSELECTED ( 'Transactions' ),
'Transactions'[Date] = SELECTEDVALUE ( 'Transactions'[Date] )
)
)
RETURN
DIVIDE ( _inditrans, _permonthtrans, 0 )
Best Regards
@venkataramana Drop down the arrow for % measure, choose Show As and then Percent of Grand Total?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |