create area chart with green and red colors to indicate profit and loss
I have created area chart that that shows profit and loss % over time. I would like to show the loss (negative part) in red color and the profit ( positive part) in geen color. i created 2 measures one for profit % and one for loss % positive p&l = var pl=[p&l %] var result= IF(pl>0 , pl,0) return result negative p&l = var pl=[p&l %] var result= IF(pl<0 , pl,0) return result when i added the measures in the chart it looked like: any idea on how to create the area chart with green/red colors instead of 1 color
Custom Table Chart idea/Suggestion
Hi. I Have a requirement to show data in a table chart but with some different view(As screenshot) Please find the below screenshot, the custom table chart is possible in Excel but in powerbi, The below chart is not able to acheive 1,2,3,4,5,,,,, is the month numbers, Count of City code is a measure, Sum of Sales is a calculated column Any Suggestions to acheive the same format in PowerBi? Thankscustom table chart
I Have a requirement to show data in a table chart but with some different view(As screenshot) Please find the below screenshot, the custom table chart is possible in Excel , The below chart is not able to acheive in Powerbi I have tried using matrix visual but not able to acheive completely. In Single Table chart have display 3 parts(As per Screenshot) 1,2,3,4,5,,,,, is the month numbers, Count of City code is a calcualted measure, Sum of Sales is a calculated column ThanksNeed to build a line and stacked column chart - struggling with it
Hey there, I want to build a line and stacked column chart, its components will be LINE VALUES: - shows the cumulative number of PN (part numbers) at the end of every month (the table below shows values for August, for example) - Details: When we see one PN number several times in a month (like PN 1282370 in August) - we count it as 1. We count every blank value in the PN column as a separate PN (like, we don't know whether they are the same or not) SHARED AXIS: - Would be just a name of the month COLUMN SERIES: - Values from the "Family" column - Details: There are multiple families Some family values are blank, too COLUMN VALUES: - Count each "Family" type: If we take August values from the table below, the count would be: 2 for family S, 1 for blank. Why? Because we have to keep in mind the "Project Name" column: So, for the month of August, Project "S 3" would have 3 PNs at risk Project "H 6" would have 1 PN at risk Project "300k" would have 3 PNs at risk Total: 7 PNs at risk The count of "Family" at the end of August would be 2: a count of 1 for family type S, and 1 value for the blank value. Table for the chart: help me, guys and gals, I beg you😭 amitchandak
