Hi ! thanks for the instructions! super informative!! I followed all steps and created mine, works like a charm ! with one question please, the [Age] data seems to be integer, and when it is "decimal" e.g: 8.7, 2.63 etc, the histogram no longer works, do i need to make any adjustments for decimal data? Thanks !! appreciate it !
Would this work for a time series? E.g group by 15 minutes interval, 1 hour interval, etc. And does the method you showed only work for import data, or would it also work with Direct Query?
This is really neat, but if you try to visual filter multiple bands i.e. orange bars in your example it wont work, unless the band size is 1. For example if you just click one bar every other graph in a visual filters out perfectly. But for example if I have a band size of 10 years of age and I multiselect 50 and 60 bars with ctrl key (which is supposed to show all ages from 50 to 69 years old) it actually shows only ages 50 and 60 years old. However if I use band size of 1 everything works.
Hi, Might be a little late for this response. But the way this works is that you are filtering the data to only include the ages 50-60. Because the grouping is done dynamically based on min and max of age, the minimum age is 50 and the maximum is 60. This gets split into bins with the size of 10 starting at 50. The 50 Bin probably shows all ages 50-59 and the 60 bin shows the age of 60 alone. if you would want to filter the complete 50 and 60 bins, it works for me to actually filter the age band table (the column which is generated with generateseries() ). if i set a slicer on that column between 50 and 60 then i see both bins in their entirity. Hopefully this might still help you and otherwise it might help others with similar problems :)
I want the same thing for time interval like I have time in hh:mm:ss format like if user select 5 in a slicer then my date range will become in 00:05, 00;10,00:15 ... upto 23:59:59 now if user select 10 then my time range will become 00:00,00:10,00:20 and so on can you please tell me how to do that?
You will need to have a DATE table and a TIME table and their relationship in the FACT table, then use measures to filter these by one another. I have some articles for each of these areas on RADACAD website.
Hi I have a doubt in powerbi.. Please can you help me.. I am developing a powerbi for a insight case.. I have all priority incidents say p1, p2 and p3.. For all months.. I want to plot a graph for only p1 incidents across months like x as is should MMM yyyy format.. When I tried to put.. Since for p1 incidents are not there on few. Onths those months not showing in graph.. I tried enabling show items with no data not working.. When I try to expand on drill option.. Then I can see future months also like I can see month upto Dec 2020.. Where it should be only upto Marc 2020.. So ease help me here
Hi ! thanks for the instructions! super informative!! I followed all steps and created mine, works like a charm ! with one question please, the [Age] data seems to be integer, and when it is "decimal" e.g: 8.7, 2.63 etc, the histogram no longer works, do i need to make any adjustments for decimal data? Thanks !! appreciate it !
Does this concept work with a measure rather than a column like age in this example?
No answer?
Could you use this with a measure from a calculation group that allows users to also slice on measures?
Would this work for a time series? E.g group by 15 minutes interval, 1 hour interval, etc. And does the method you showed only work for import data, or would it also work with Direct Query?
This is really neat, but if you try to visual filter multiple bands i.e. orange bars in your example it wont work, unless the band size is 1. For example if you just click one bar every other graph in a visual filters out perfectly. But for example if I have a band size of 10 years of age and I multiselect 50 and 60 bars with ctrl key (which is supposed to show all ages from 50 to 69 years old) it actually shows only ages 50 and 60 years old. However if I use band size of 1 everything works.
Hi, Might be a little late for this response. But the way this works is that you are filtering the data to only include the ages 50-60. Because the grouping is done dynamically based on min and max of age, the minimum age is 50 and the maximum is 60. This gets split into bins with the size of 10 starting at 50. The 50 Bin probably shows all ages 50-59 and the 60 bin shows the age of 60 alone. if you would want to filter the complete 50 and 60 bins, it works for me to actually filter the age band table (the column which is generated with generateseries() ). if i set a slicer on that column between 50 and 60 then i see both bins in their entirity. Hopefully this might still help you and otherwise it might help others with similar problems :)
true
I want the same thing for time interval
like I have time in hh:mm:ss format like if user select 5 in a slicer
then my date range will become in 00:05, 00;10,00:15 ... upto 23:59:59
now if user select 10 then my time range will become 00:00,00:10,00:20 and so on
can you please tell me how to do that?
You will need to have a DATE table and a TIME table and their relationship in the FACT table, then use measures to filter these by one another. I have some articles for each of these areas on RADACAD website.
@@RADACAD can you please share the article link
My requirement is after generating data in x axis I want count of id in y axis
Hi I have a doubt in powerbi.. Please can you help me..
I am developing a powerbi for a insight case..
I have all priority incidents say p1, p2 and p3.. For all months..
I want to plot a graph for only p1 incidents across months like x as is should MMM yyyy format.. When I tried to put.. Since for p1 incidents are not there on few. Onths those months not showing in graph..
I tried enabling show items with no data not working.. When I try to expand on drill option.. Then I can see future months also like I can see month upto Dec 2020.. Where it should be only upto Marc 2020..
So ease help me here