Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
petar_kisdobran
Frequent Visitor

Table with predefined form with multiple measures in columns

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

petar_kisdobran_0-1677748073564.png            petar_kisdobran_3-1677748125054.png

 

Need to have

petar_kisdobran_2-1677748105265.png

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

 

 

 

1 ACCEPTED SOLUTION
10 REPLIES 10
Ahmedx
Super User
Super User

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)

....

  "", "",
    UNICHAR ( 160 ), "",
    FORMAT ([Act],"#")
)
 
and to change it for instance to Unichar (130),"", is it possible to add an transparency format to that line ?
eg
....
format (unichar130),#3E4AFF00",
FORMAT ([Act],"#")
)
 
Thank you so much for all!
 
My best,
Petar
 
 
 
Ahmedx
Super User
Super User

Hi ! explain how to count the following measures
Margin%
EBITDA
EBITDA%

apologies,

margin % = margin / revenue

EBITDA = margin - other expenses

EBITDA % = EBITDA / revenue

BR

Petar

Screen Capture #403.png

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... 

petar_kisdobran_0-1677770219652.png

 

this is character 160

https://dropmefiles.com/vdZfi

awesome! is it possible to add additional ones (eg to make order 10) or this is all we can use?

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.