Want to display my measure result which is a string value in a moving way in my Power BI Report.

[Anonymous]

i have measure eg,

Scroler = IF([EUC Max Color]="Red","Euc User services Need for Focus",IF([App Max Color]="Red" ,"Application services Need for Focus",IF([Infra Max Color]="Red","Infrastructure services Need for Focus")))

I want to display my result string in a moving way (like marquee).

[v-kongfanf-msft · Accepted solution]

Hi @Anonymous ,

Is the following result what you want:

ScrollingText = "Below is the filtered result: " & [Scroler]

Scroler = 
IF (
        MAX('Table'[EUC Max Color]) = "Red",
    "Euc User services Need for Focus",
    IF (
        MAX('Table'[App Max Color])= "Red",
        "Application services Need for Focus",
        IF (MAX('Table'[InfraMax Color]) = "Red", "Infrastructure services Need for Focus" )
    )
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi everyone i have done this task by using a visual scroller and by calculated column ,

Thanks

[v-kongfanf-msft · Accepted solution]

Hi @Anonymous ,

Is the following result what you want:

ScrollingText = "Below is the filtered result: " & [Scroler]

Scroler = 
IF (
        MAX('Table'[EUC Max Color]) = "Red",
    "Euc User services Need for Focus",
    IF (
        MAX('Table'[App Max Color])= "Red",
        "Application services Need for Focus",
        IF (MAX('Table'[InfraMax Color]) = "Red", "Infrastructure services Need for Focus" )
    )
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-kongfanf-msft Thanks for your reply but i wanted to use it as a scroller and i have done it by importing a visual name Scroller and by using a calculated column as measure was not working in scroller. But thanks for your reply.

thanks

[Jonvoge]

Hi Gurpreetsingh55

To accomplish this, you will need to install a Custom Visualisation to help you render HTML. One example is the HTML VizCreator. Download the viz by going to the marketplace:

After downloading, you may create a calculated measure to output HTML code, similar to what is being done in this video, including marquee type html: How to create moving text or images in Power BI ⬅ ➡ (youtube.com)

___________________________________...


LinkedIn, Sessionize, or my blog Downhill Data

[Anonymous]

Hi @Jonvoge i have already tried this one it is not usefull for measures you can only display a string but not a measure result.