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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
AudreyRene
Regular Visitor

Modify vizualisation

Hello, 

 

Im new in Power BI and im wondering 2 things for my visualization.

 

First, how to use value instead of percentage (axis y) ?

AudreyRene_1-1712867998449.png

Second how can i make the first visualization to look like the second visualization ? I dont know how to put the names (ghassen, nathalie and marcel) and the month on axis x 

 

AudreyRene_2-1712868203826.png

to

 

AudreyRene_3-1712868495377.png

 

 

 

 

2 ACCEPTED SOLUTIONS
v-cgao-msft
Community Support
Community Support

Hi @AudreyRene ,

For percent stacked bar charts, modifying the Y-axis to a numeric value would be odd, as it would not accurately reflect the size of the values under each category.

1. It is recommended that you use stacked bars and create a measure like:

Measure = 
VAR __denominator = CALCULATE( SUM( 'financials'[Profit] ), ALLEXCEPT( 'financials','financials'[Product] ) )
VAR __numerator = SUM('financials'[Profit])
VAR __rate = FORMAT(DIVIDE(__numerator,__denominator),"Percent")
RETURN
__rate

And apply it to the data label's value format:

vcgaomsft_0-1712888845136.png


2. You can put [Names], [Month Name] on the x-axis.

vcgaomsft_1-1712889148867.png

Then you need to create a conditional format to display different colors according to [Names].

Measure 2 = 
SWITCH(
    SELECTEDVALUE('financials'[Country]),
    "Canada","Red",
    "France","Blue",
    "Germany","Yellow"
)

vcgaomsft_3-1712889508565.png

Output:

vcgaomsft_2-1712889473305.png

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

View solution in original post

Hi @AudreyRene ,

Try using a clustered bar chart and placing [name] in the value of Legend.

vcgaomsft_0-1713143008583.png

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

View solution in original post

3 REPLIES 3
v-cgao-msft
Community Support
Community Support

Hi @AudreyRene ,

For percent stacked bar charts, modifying the Y-axis to a numeric value would be odd, as it would not accurately reflect the size of the values under each category.

1. It is recommended that you use stacked bars and create a measure like:

Measure = 
VAR __denominator = CALCULATE( SUM( 'financials'[Profit] ), ALLEXCEPT( 'financials','financials'[Product] ) )
VAR __numerator = SUM('financials'[Profit])
VAR __rate = FORMAT(DIVIDE(__numerator,__denominator),"Percent")
RETURN
__rate

And apply it to the data label's value format:

vcgaomsft_0-1712888845136.png


2. You can put [Names], [Month Name] on the x-axis.

vcgaomsft_1-1712889148867.png

Then you need to create a conditional format to display different colors according to [Names].

Measure 2 = 
SWITCH(
    SELECTEDVALUE('financials'[Country]),
    "Canada","Red",
    "France","Blue",
    "Germany","Yellow"
)

vcgaomsft_3-1712889508565.png

Output:

vcgaomsft_2-1712889473305.png

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

Hello,

 

First, Thank You ! The first solution works. For the second, i understand your example, but i dont know how to make it with my data 

 

I need to have this visualization. 

 

Axis x = Regroup by month of each year 

Secondary Axis x = Regroup by the name of the person who make the transaction

Axis y = Number of transaction 

 

AudreyRene_0-1712934970057.png

 

Hi @AudreyRene ,

Try using a clustered bar chart and placing [name] in the value of Legend.

vcgaomsft_0-1713143008583.png

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.