Forum Discussion

Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper User
3 years ago

Using Measure as Category axis and a Column Count as Y Axis

Hi, I went through couple of solutions looking for the Visual representation that I am trying to achieve but with not much luck writing this post I am giving an oversimplified example here.  Th...
Need Help
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi , Thejeswar 

According to your description, you want to use the {"<=200",">200"} on the X-axis.

Here are the steps you can refer to :
(1)We need to cretae a table as X-axis.

Table 2 = {">200","<=200"}

(2)Then we need to create a measure like this:

Measure = var _t =ADDCOLUMNS( SUMMARIZE('Table','Table'[Attribute],'Table'[Segment], "Value", SUM('Table'[Value])) ,"Flag" , IF([Value]>200 ,1,-1))
var _cur_x = MAX('Table 2'[Value])
var _less = FILTER(_t,[Flag] =-1)
var _larger =FILTER(_t ,[Flag]=1)
return
IF(_cur_x="<=200",COUNTROWS(_less),COUNTROWS(_larger))

 

(3)Then we can meet your need :

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly