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
Icon for Community Support rankCommunity 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!