How to see same text format in Word Document as in Power BI Any Visual

[KR300]

Hi All, We'll have a daily updates for the leadership. So, we wanna send a message like below format - More/less Info but in the Same format ( Let's say: Status update for a Release for a Product )

High Level Status:

Release Status:

QA2 regression is still blocked due to Some cache bug  FPR-116540

Dynamic Scheduling, VDM and Visual Inspection modules regression is yet to be started and teams are waiting for the bug fix-FPR-116540.

Fix for bug-FPR-116572 was deployed to QA2 but issue is intermittently replicable, hence the bug is reopened.

Release Risks:  Blocker

ABC team has tried deploying bug fix FPR-116540 ,  and deployment was not successful . Issue is persisting from AWS end for ECS service Split and team is currently working with AWS and Split teams.

Open Action Items:

QA2 regression is blocked . Teams are not able to proceed  and are waiting or the fix to be deployed for Somecache  bug FPR-116540.

Go/No-Go Decision:  Scheduled on Monday July25th

Key Value Deliverables: No value drop deliverables (To be explored)

Current Scenario: I am getting this data from Jira APL as a HTML code & I am parsing code & did Multiple ETL operations. Getting all the info as a single row line into PBI Desktop.

Is it possible to do the same formatting like above in Power bi?

[danextian]

Hi @KR300 

You will need to generate an html code referencing measures/columns and use the html visual to render that. Here's a sample:

Sales Amount = SUM(Sales[Amount])

Sales Target = 100000

Sales HTML Card = 
VAR SalesValue = [Sales Amount]
VAR TargetValue = [Sales Target]
VAR Status = 
    SWITCH(
        TRUE(),
        SalesValue >= TargetValue * 1.2, "Excellent",
        SalesValue >= TargetValue, "Good",
        "Needs Improvement"
    )
VAR TextColor = 
    SWITCH(
        Status,
        "Excellent", "white",
        "Good", "black",
        "red"
    )
VAR BackgroundColor = 
    SWITCH(
        Status,
        "Excellent", "green",
        "Good", "yellow",
        "lightcoral"
    )
RETURN 
    "<div style='width:300px; padding:10px; border-radius:8px; background-color:" & BackgroundColor & "; color:" & TextColor & "; text-align:center; font-family:Arial, sans-serif;'>
        <h2>Sales Performance</h2>
        <p style='font-size:20px;'>Sales Amount: $" & FORMAT(SalesValue, "#,##0") & "</p>
        <p style='font-size:16px; font-weight:bold;'>Status: " & Status & "</p>
        <p style='font-size:14px;'>Target: $" & FORMAT(TargetValue, "#,##0") & "</p>
    </div>"

These are the apps I would use:

[KR300]

Thanks @danextian , for you answers. I will try to resolve the issue based on your input

If you don't mine. can you send a .pbix file with solution

[danextian · Accepted solution]

I don't have one specific for your use case but the attached pbix  is one ways to use html. These reports also use HTML

https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Pok%C3%A9DAX-Pokemon-x-Power-BI/td-p/...

https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/MCU-Marvel-Calculation-Universe/td-p/...