Seaborn with powerBI

[Anonymous]

I am trying to quite simply plot a histogram containing the frequency at which a number occurs in my dataset. In a Juypter notebook I run 

sns.countplot(dataset['responseCode'])

And get the histogram I expect. However when I run the code in PowerBI, it sets everything to 1.0. Does anyone know why? 

[parry2k]

@Anonymous I'm not python/R developer, if you share sample data with expected output, I can help. Just to let you know, you can use R and Python visual in Power BI as well. 🙂

[Anonymous]

Hi @parry2k 

The data will look something like

Response code

500

500

200

200

200

200

200

500

I want to count the number of times 500 or 200 appears. When I run in Juypter I get 

However when I run in powerBI, the same piece of code I get.

I dont know why its normalising to 1

[v-lili6-msft · Accepted solution]

hi @Anonymous 

For your case, just try this simple way:

Create a measure as below:

Measure = COUNTA('Table'[Response code])

Then create a bar visual as below:

and here is sample pbix file, please try it.

Regards,

Lin

[Anonymous]

Hi @parry2k  @v-lili6-msft 

Thanks for both of your help. So i have the plot as shown by @v-lili6-msft But i dont want the spaces in between i really want it to be discrete catagories as shown in the seaborn plot above

[Anonymous]

Actually I have solved it. Just needed to switch to catagorial 🙂 

Thanks everyone will mark as solved

[parry2k]

@Anonymous what is the aggregation on Value section of chart you used?

[Anonymous]

At the moment it is set to don't summerise. I tried changing to count and count distinct. It still gives me rubbish

[parry2k]

@Anonymous it is not possible that you have dont summarize, in value section, it has to be some aggregation until your column is not number. 

Add following measure and use that in value 

Total Rows = COUNTROWS ( YourTable )

[Anonymous]

I dont really understand what you mean. I am new to powerbi, how do I add a measure?

 

[parry2k]

@Anonymous no worries, here it is