Latest questions in Power BI

0 votes
1 answer

How do I create a line chart?

Hi, From the data mentioned above, you can ...READ MORE

May 10, 2019 in Power BI by Avantika
• 1,520 points
714 views
0 votes
1 answer

How do you change the tables in chart filters?

Hi, You can use the following measure. Measure 2 = ...READ MORE

May 10, 2019 in Power BI by Avantika
• 1,520 points
628 views
0 votes
0 answers

How do you change the tables in chart filters?

I am working on a report that shows ...READ MORE

May 10, 2019 in Power BI by anonymous
635 views
0 votes
1 answer

Difference between the number of days user(client) has logged into the website.

Hi Rajesh, Use below code -  Column 4 = ...READ MORE

May 9, 2019 in Power BI by Cherukuri
• 33,030 points
585 views
0 votes
1 answer

How to categorize state, pin and city in power bi (Address)

After loading dataset, you can split in ...READ MORE

May 10, 2019 in Power BI by anonymous
• 33,030 points
3,544 views
0 votes
1 answer

show data even for no data - power BI

Hi Latha, To show rows with empty data ...READ MORE

May 9, 2019 in Power BI by Cherukuri
• 33,030 points
19,597 views
0 votes
1 answer

Text into URL

Hi Riya, To convert a URL or hyperlink text ...READ MORE

May 9, 2019 in Power BI by Cherukuri
• 33,030 points
448 views
0 votes
1 answer

Conditional Formatting - Power BI

Hi Priya, Create a parameter and add it ...READ MORE

May 9, 2019 in Power BI by anonymous
• 33,030 points
944 views
0 votes
1 answer

Why does a reference to a value in previous row throw this Expression.Error?

If you have multiple steps after the ...READ MORE

May 9, 2019 in Power BI by Avantika
• 1,520 points
817 views
0 votes
1 answer

append a column to another column

Hi Priya, You can use concatenate to join ...READ MORE

May 8, 2019 in Power BI by Cherukuri
• 33,030 points
616 views
0 votes
1 answer

Count - using If within period of dates.

Hi Sindhu, Use below DAX code to create ...READ MORE

May 8, 2019 in Power BI by Cherukuri
• 33,030 points
705 views
0 votes
1 answer

Datediff with column having no value/ blank

Hi Karthick, Use the below DAX code - ...READ MORE

May 8, 2019 in Power BI by Cherukuri
• 33,030 points
6,039 views
0 votes
1 answer

Multiple slicer using same field

Hi Anitha, You can use the same filed ...READ MORE

May 8, 2019 in Power BI by Cherukuri
• 33,030 points
5,363 views
0 votes
1 answer

dates in power bi

Hi Raju, You can show visual for a ...READ MORE

May 7, 2019 in Power BI by Cherukuri
• 33,030 points
526 views
0 votes
1 answer

all and allExcept - DAX functions

Hi Satish, All function is used when you ...READ MORE

May 7, 2019 in Power BI by Cherukuri
• 33,030 points
6,880 views
0 votes
1 answer

conditional formatting - color to show few rows from acndition

Hi Priya, Create a matrix with region and ...READ MORE

May 7, 2019 in Power BI by Cherukuri
• 33,030 points
555 views
0 votes
1 answer

count of string in pie chart

Hi Prakash, Select the measure and measure that ...READ MORE

May 7, 2019 in Power BI by Cherukuri
• 33,030 points
1,644 views
0 votes
1 answer

How To use R Integration in Power BI?

Hi,  There are a lot of packages available ...READ MORE

May 3, 2019 in Power BI by Avantika
• 1,520 points
2,631 views
0 votes
1 answer

How do I use Python scripts in Power BI?

Hi, You can create interactive reports out of ...READ MORE

May 2, 2019 in Power BI by Avantika
• 1,520 points
2,432 views
0 votes
1 answer

calculation with condition and filter

Hi Preethi, Follow the below steps: 1. Create a ...READ MORE

May 2, 2019 in Power BI by Cherukuri
• 33,030 points
898 views
0 votes
1 answer

Create custom tables in power BI

Hi Sindhu, You can create custom tables by clicking ...READ MORE

May 2, 2019 in Power BI by Cherukuri
• 33,030 points
14,500 views
0 votes
1 answer

Rank - Power BI

Hi Anitha, Drop Category, product-id, and sales into ...READ MORE

May 2, 2019 in Power BI by Cherukuri
• 33,030 points
918 views
0 votes
1 answer

Total sales for orders till current date using MTD

Hi Riya, Use the below code to find ...READ MORE

May 2, 2019 in Power BI by Cherukuri
• 33,030 points
1,193 views
0 votes
1 answer

Most recent order sales from customers

Hi Nithin, You can use LASTDATE() to fetch ...READ MORE

May 2, 2019 in Power BI by Cherukuri
• 33,030 points
674 views
0 votes
1 answer

Top N - Power BI

Hi Priya, You can use Rank () or ...READ MORE

May 2, 2019 in Power BI by Cherukuri
• 33,030 points
538 views
0 votes
1 answer

Calculate and filter function - DAX

Hi Praneeth, Calculate () by default perform calculations ...READ MORE

May 2, 2019 in Power BI by Cherukuri
• 33,030 points
1,335 views
0 votes
1 answer

Power BI : Status Count

Try COUNT, COUNTX, or COUNTROWS . READ MORE

Apr 26, 2019 in Power BI by Shubham
• 13,490 points
1,279 views
0 votes
1 answer

To calculate conditional running total in power query

Try Table Buffer after adding the index, or ...READ MORE

Apr 26, 2019 in Power BI by Shubham
• 13,490 points
2,245 views
0 votes
0 answers

How to Fix error "DataFormat.Error: We couldn't convert to Number"

Hi,  I am getting below error "DataFormat.Error: We couldn't ...READ MORE

Apr 22, 2019 in Power BI by Lavdeep
• 120 points
14,681 views
0 votes
1 answer

How to use Python Scripts in Query Editor?

Hi, In order to use Python Visuals you need ...READ MORE

Apr 11, 2019 in Power BI by Avantika
• 1,520 points
3,671 views
0 votes
1 answer

How do you use R visuals in Power BI Desktop?

Hi, In order to use R Visuals you ...READ MORE

Apr 10, 2019 in Power BI by Avantika
• 1,520 points
718 views
0 votes
1 answer

Count of Id within another Id

Hi Kalyan, Follow below steps: 1. Create a slicer ...READ MORE

Apr 17, 2019 in Power BI by Cherukuri
• 33,030 points
876 views
0 votes
1 answer

Adding values of two columns in two tables

Hi Anshuli, You can either create a separate ...READ MORE

Apr 10, 2019 in Power BI by Cherukuri
• 33,030 points
1,320 views
0 votes
1 answer

count of orders on n hour basis - Power BI

Hi Nithin, You can create a measure to ...READ MORE

Apr 11, 2019 in Power BI by Cherukuri
• 33,030 points
981 views
0 votes
1 answer

Chart with only some values in field in a graph in power BI?

Hi Banu, While creating a chart, put the ...READ MORE

Apr 10, 2019 in Power BI by Cherukuri
• 33,030 points
968 views
0 votes
1 answer

Power BI Embedded: DMTS_DatasourceHasNoCredentialError

You'll need to call the PATCH data source API Patch Gateway ...READ MORE

Apr 10, 2019 in Power BI by Shubham
• 13,490 points
2,203 views
0 votes
2 answers

Can I get rid of the grey border on the report visuals with power bi embedded?

It's just a simple css code to ...READ MORE

Apr 19, 2020 in Power BI by Prateek Mehta
5,495 views
0 votes
1 answer

Calling Azure API using Power BI with Next Link

Try this let iterations = ...READ MORE

Apr 9, 2019 in Power BI by Shubham
• 13,490 points
1,925 views
0 votes
1 answer

How do I use Python Visualizations in Power BI?

Hi, You can create interactive reports out of ...READ MORE

Apr 8, 2019 in Power BI by Phalguni
• 1,020 points
982 views
0 votes
1 answer

add bar colors in power bi under condition

Hi Sindhu, Follow below steps to add colors ...READ MORE

Apr 8, 2019 in Power BI by Cherukuri
• 33,030 points
640 views
0 votes
1 answer

Show orders from past n months

Hi banu, Create a column like below, diff = DATEDIFF(Orders[Order ...READ MORE

Apr 8, 2019 in Power BI by Cherukuri
• 33,030 points
600 views
0 votes
1 answer

Show orders from past n days in Power BI?

HI banu, Create a column like below, diff = ...READ MORE

Apr 8, 2019 in Power BI by Cherukuri
• 33,030 points
943 views
0 votes
1 answer

Find number of days between 2 dates.

Hi Sindhu, Create a column with below code. ...READ MORE

Apr 8, 2019 in Power BI by Cherukuri
• 33,030 points
1,305 views
0 votes
1 answer

Power BI : Counting Failures

Try the following measure: Count of fails = ...READ MORE

Apr 5, 2019 in Power BI by Upasana
• 8,620 points
1,300 views
0 votes
1 answer

Power BI getting 2 week back same day value

You can use DATEADD() function to compute the 14 ...READ MORE

Apr 5, 2019 in Power BI by Upasana
• 8,620 points
1,384 views
0 votes
1 answer

Dax: Sum of values from many columns in a row

Yes, you can. Try to "Unpivot other columns" ...READ MORE

Apr 3, 2019 in Power BI by Upasana
• 8,620 points
10,506 views
0 votes
1 answer

Power BI Embedded : Importing Packages

This should help you out. https://www.nuget.org/packages/PowerBI.N ...READ MORE

Apr 3, 2019 in Power BI by Shubham
• 13,490 points
741 views
0 votes
1 answer

How to Transpose unique values and get matching values in rows?

I think this query should do what ...READ MORE

Apr 1, 2019 in Power BI by Upasana
• 8,620 points
1,530 views
0 votes
1 answer

Cumulative row data over last 12 months in Power Query

Basically, what you do is,  Add an Index,  Group ...READ MORE

Apr 1, 2019 in Power BI by Upasana
• 8,620 points
3,144 views
0 votes
1 answer

How do I convert month format in Power BI?

Hi, This can easily be done using DAX ...READ MORE

Mar 27, 2019 in Power BI by Avantika
• 1,520 points
5,024 views