Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

reference band?

hello everyone.   I have been trying to create a graph using the "line and Clustered column Chart" to achieve somewhat similar graph as above. i currently managed until here:     I ...
Need Help
  • samdthompson's avatar
    samdthompson
    9 years ago

    GilbertQ, I dont think an average value was asked for. I was suggesting something like this:

     

     

    If you want the average then it would be easier to make a measure using something like:

     

    Average = calculate(AVERAGE(Table1[Value]),all(Table1[Month]))

     

    and create:

     

     

     

    // If this is a solution please mark as such

poonam's avatar
poonam
Regular Visitor
8 years ago

Hi Joylili, Did you get any luck creating bands in Power BI, if yes could you please share. We are trying to achieve similar visulaization where I need bands.

 

I have 4 calculated columns in my dataset, which are 25th percentile, 50th Percentile, 75th Percentile and highest values, I need bands accoring to these columns. I also have a measure and a time dimension which I use for showing the line chart.

 

It would be great if you share.

 

Thanks!