Hi Everyone,
I have few weeks in using Power BI and I will like to get a suggestion about use data distribution that is not Histogram.
My idea was the user access the report in the PBI Server and jump directly to filter for what He wants to look by filtering a pre-selected data set then, for this “new data set” the power bi run the calculations and provide the histogram.
I did the manual Histogram calculation without using the automatic version from Power BI because I have to calculate manually the bins depending of the data set.
I just learn in the hard way that calculated virtual tables and calculated columns only get update when the data model is refresh, and then only calculate measure get update at query time (It means if the data get filtered the calculate measure change).
The histogram calculation has in this moment Cal. Columns [ Bin, Bin Names (a.k.a. R1 to Rn), Bin No and Bins sizes] and Cal. Measure [Bin Size(Distinct) {a.k.a. Bin Size}, Frequency and Relative of Frequency ( percentage Freq) ]
Thanks in advance.
