DAX

Question

Hi Team,&nbsp;I have a data set&nbsp; and i want to create a visual using that oneThe above shows the data and i want to create a visual that show no of accounts in a barchart and its axis is revenue interval(shown in below image)i made solution ,i have added a calculated column&nbsp; &nbsp;and its working for indivdual months.&nbsp;But the issue was if select multiple month in slicer am not able to sum the revenue and not able to show interval dynamically.ie if revenue in first month 1253 and second month was 92856 ,when select both months i want interval 10000-100000 buts now its showing as two intervals 0-10000 and 10000-100000.Can any one please help me to solve this

amitchandak · Answer

Anonymous , There are two types of intervals you can create. One static which is a column 
&nbsp;
Switch(True(),
[Revenue] &lt;10000, "&nbsp;&nbsp;&nbsp; 0 -10000",
[Revenue] &lt;50000, "&nbsp;&nbsp;&nbsp; 10000 -50000",
//Add other
"GT 1,000,000"
)
&nbsp;
Another is dynamic segmentation
&nbsp;
Dynamic Segmentation Bucketing Binninghttps://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

anonymous · Answer

Hi Amit,&nbsp;Its help to calculate the no of accounts ,but when am trying to filter its not workingi clicked on first visual ,but the second one not filtering based on that,can you please help&nbsp;

Forum Discussion

DAX

2 Replies

Related content

Dax

DAX

DAX Behavior

DAX Formula Help

DAX