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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
unnijoy
Post Partisan
Post Partisan

Horizontal text display with data

I have a data table like below.

unnijoy_0-1686739029679.png

I want to get the name's and corresponding sales amount horizontally as shown below.

unnijoy_1-1686739243350.png

 

how can we show the data like this.



 

1 ACCEPTED SOLUTION
ppm1
Solution Sage
Solution Sage

Here's an example that shows one way to do it.

ppm1_0-1686743700782.png

This measure is in the card visual below the table.

TotalsString =
VAR CitySales =
    ADDCOLUMNS ( DISTINCT ( Stores[City] ), "cSales", [Total Sales] )
RETURN
    "Total Sales: "
        & CONCATENATEX (
            CitySales,
            Stores[City] & ": "
                & FORMAT ( [cSales], "$0,,.0M" ),
            " "
        )

 

Pat

 

Microsoft Employee

View solution in original post

3 REPLIES 3
ppm1
Solution Sage
Solution Sage

Here's an example that shows one way to do it.

ppm1_0-1686743700782.png

This measure is in the card visual below the table.

TotalsString =
VAR CitySales =
    ADDCOLUMNS ( DISTINCT ( Stores[City] ), "cSales", [Total Sales] )
RETURN
    "Total Sales: "
        & CONCATENATEX (
            CitySales,
            Stores[City] & ": "
                & FORMAT ( [cSales], "$0,,.0M" ),
            " "
        )

 

Pat

 

Microsoft Employee

Hi @ppm1 the solution that you gave me is working.
Can you please tell me how i can make "Total Slaes" Bold. Is it possible to do it.

Can't think of an easy way to do that. Probably possible with the HTML viewer visual.

 

Pat

Microsoft Employee

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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