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
Sum Filter the value in visual chart
Hi, I have 02 column chart to see the total of per date,day or per hour. how to get the sum value by filtering because the measure I make shows different value. thank you in advance.. My table: Date Day Time Sample Total 1-Aug Tue 12:00:00 AM Item 1 325 2-Aug Wed 12:00:00 AM Item 1 315 3-Aug Thu 12:00:00 AM Item 2 340 4-Aug Thu 3:00:00 AM Item 2 285 Measure Item 1 = CALCULATE( SUM('Equipment Query'[Total]), 'Equipment Query'[Sample] IN {"Item 1"})
Need help plotting chart
Hi all, May need your help in plotting a radar chart . I need to plot a radar chart to show an Overview . All the actual values from the images below i currently have in different measures which are located in different table . How do i actually plot the radar chart in Power BI.( I assume we need to put the measures in a single table to plot this by each category). How do i achieve this ? This is what i have tried..Eventhough i put mutiple measures it does not plotted or show as image above Thanks and Regards, Hairul
