Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Histogram with dynamic axis

Hi PBI Community,   I am trying to build a report that uses a histogram to show the distribution in occupancy and I need help. Pbix below   https://www.dropbox.com/s/xzq95otm3ki14b2/Histogram%20q...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    After a lot test, i find it.

    Please try to create a table first as below:

    X-Axis = GENERATESERIES(0,1,0.01)

    Then create a measure:

    Measure Value = COUNTROWS(FILTER(SUMMARIZE('Census','Census'[Date],"AVG",ROUND([Average Occupancy],2) ),[AVG] = ROUND(SELECTEDVALUE('X-Axis'[Value]),2)))

    When you select all in two slicers, it shows as my original reply:

    When you select North only in Building slicer, the x-axis has dynamically changed:

    Here is my test pbix file:

    pbix 

    If i have solved your issue, please mark my answer as a solution for others to see.

    Thanks!

     

    Best Regards,

    Giotto Zhi