Forum Discussion
Creating histogram using measure and dimension from data warehouse
- Anonymous1 year ago
Thanks for the reply from Poojara_D12 and Fowmy , please allow me to provide another insight:
Hi, Anonymous
Have the answers from Poojara_D12 and Fowmy resolved your issue? If so, please mark their responses as the solution. This will help others with similar questions find the answers more quickly.
Regarding your question, I have also created the following example:
1.Firstly, here is my sample data:
Bins = DATATABLE( "Bin", INTEGER, { {0}, {10}, {20}, {30}, {40}, {50}, {60}, {70}, {80}, {90}, {100} } )2.Secondly, I have created the following calculation table:
3.Next, I have created the following measures:
Frequency = COUNTROWS( FILTER( TestData, TestData[Value] >=MAX('Bins'[Bin])&& TestData[Value] < MAX('Bins'[Bin]) + 10 ) )4.Here's my final result, which I hope meets your requirements.
Please find the attached pbix relevant to the case.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply from Poojara_D12 and Fowmy , please allow me to provide another insight:
Hi, Anonymous
Have the answers from Poojara_D12 and Fowmy resolved your issue? If so, please mark their responses as the solution. This will help others with similar questions find the answers more quickly.
Regarding your question, I have also created the following example:
1.Firstly, here is my sample data:
Bins =
DATATABLE(
"Bin", INTEGER,
{
{0},
{10},
{20},
{30},
{40},
{50},
{60},
{70},
{80},
{90},
{100}
}
)
2.Secondly, I have created the following calculation table:
3.Next, I have created the following measures:
Frequency =
COUNTROWS(
FILTER(
TestData,
TestData[Value] >=MAX('Bins'[Bin])&& TestData[Value] < MAX('Bins'[Bin]) + 10
)
)
4.Here's my final result, which I hope meets your requirements.
Please find the attached pbix relevant to the case.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Anonymous1 year agoNot applicable
Hi
Thank you for the solution. I think switching from SQL Server thinking to DAX thinking is not easy.
It appears Microsft removed its perfectly good histogram visualization from the Powerbi market place in 2022. It would be good for that to be added back in again.
Excel has histogram graphs built in, why doesnt powerbi? Its a mystery.