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

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Please try to create this calculated table first:

Table = SUMMARIZE(Census,Census[Date],"Column",[Average Occupancy])

Then create a measure to count date:

Measure 2 = DISTINCTCOUNT(Census[Date])

The result shows:

Here is the changed pbix file:

pbix 

Hope this helps.

 

Best Regards,

Giotto Zhi

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks! This is really close. 

 

The histogram in the file does represent the table as is, but if I apply any filters (e.g., just looking at the north building) then the histogram does not change. Any idea on how to enable that functionality?

 

Thanks again - I really appreciate your thoughts!

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      It worked! Thank you so much - you're amazing!