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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Percentage of the lines on histograms

Hey Guys! having some trouble here. This is the histogram I have:

Mbuenahora_0-1605304715130.png

The thing is: I don't wannt to show the raw numbers, I wanna show the percentage of heach month. PB has the option: "show values as" (not sure the translation from spainsh, but kind of) But It only has the option to do it as a percentage of the total, like each part of the month divided on the total of all months:

Mbuenahora_1-1605304974610.png

(It should be like 45% on gray, 45% on blue and 10% on orange)
You know how to do it?

Thx!

 

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , Create a stacked line visual and then in line visual use measure and change it to the percent of total . enable markers and make line color same as background color

 

Percent of total.png

Anonymous
Not applicable

Doesn't work, because I need it as a percentage of the month, not as a percentage of the global total.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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