Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi everyone,
Can I kindly ask you to help me with following challenge, i have two tables, one with actual data and other with budgeted.
I appended them to have data in one query, and tried with measures (calculate function) to get needed outcome (snip below), however cannot make it in the form required (managed to get only actuals or budgeted amounts in required form, cannot add them both in one table)...
table actuals table budgeted
Need to have
Measures used: revenue act = calculate(sum('actuals'[Amount act]),'actuals'[Line]="Revenue")
same for CoS and other expenses.
Margin act = [revenue act]-[CoS act]
same made for budgeted amounts, however could not present them side by side in table....
Thank you in advance!
My best,
Petar
Solved! Go to Solution.
You can add any character and apply conditional formatting to its font color. for example make it transparent
CF = IF(SELECTEDVALUE(DimLine[Line])=UNICHAR(152),"#3E4AFF00")
sorry for torturing this much, if I would like to add transparency format to your code line unichar (bottom of the actuals measure code)
....
Hi ! explain how to count the following measures
Margin%
EBITDA
EBITDA%
apologies,
margin % = margin / revenue
EBITDA = margin - other expenses
EBITDA % = EBITDA / revenue
BR
Petar
thats great 🙂 can you please share the solution (ege PBI file or codes)?
thanks!
Could you please help me understand how have you managed to enter a space character in DimLine data (line # 7) and that PBI accept this as unique value compared to a blank row (line # 5)? If i try to add another 2x space character (eg line #10), PBI recognised it as duplicated value so I cannot do one->many relationship and your other solutions...
awesome! is it possible to add additional ones (eg to make order 10) or this is all we can use?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
74 | |
57 | |
38 | |
33 |
User | Count |
---|---|
71 | |
65 | |
58 | |
50 | |
47 |