Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to create dynamic histogram ?

Hi There,

 

I have a table with 3 columns and I want to create a dynamic histogram for them. I also want to be able to choose the number of bins from a slicer. Kind of like this:-

 

The Data looks like this 

 

I have managed to make the "Attribute"slicer using : Unpivot remaining columns after selecting "Date". & using the attribute column in the slicer field. 

As for the Number of bins, I have created a new table containing 5 rows & 1 column : 1,2...5

 

I have gone through several help posts, but I could not find the answer .
I am aware that I could do this for a single column using "New group" & binning their values.

However I need the dynamic one. 

 

Thanks.

 

P.S: I have gone through Dynamic Banding or Grouping in Power BI - Using DAX Measures - Choose the Count of Bins - RADACAD , but was unsuccessfull in recreating it.

My original data has 70 columns and 178 rows.