Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello experts,
I have below data in database. I am using Direct Query mode. When I build a table visual, it shows me only one record as the values are same in all 3 rows. I want to show all 3 rows in table visual. How to do this?
Data:
Name Customer Score Revenue
A Cust1 50 1000
A Cust1 50 1000
A Cust1 50 1000
Current o/p:
Name Customer Score Revenue
A Cust1 50 1000
Expected o/p:
Name Customer Score Revenue
A Cust1 50 1000
A Cust1 50 1000
A Cust1 50 1000
Thanks,
Anilesh
Solved! Go to Solution.
Hi, @anileshknpowerb
The function to get a random number in Power BI is Rand() and Randsbetween(). However, they both don’t support Direct query mode. The step that adds a random column in the Power query also doesn’t support Direct query mode. Then I figure out a method that used the calculated table to achieve this, you can follow my steps:
Table = ADDCOLUMNS('Table_2',"Tag",RAND())
And you can get what you want.
You can download my test pbix file here
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @anileshknpowerb
The function to get a random number in Power BI is Rand() and Randsbetween(). However, they both don’t support Direct query mode. The step that adds a random column in the Power query also doesn’t support Direct query mode. Then I figure out a method that used the calculated table to achieve this, you can follow my steps:
Table = ADDCOLUMNS('Table_2',"Tag",RAND())
And you can get what you want.
You can download my test pbix file here
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @anileshknpowerb
According to your description, you want to make the three columns that are exactly the same to display their own value in the table chart through direct query mode, you can try my steps:
Tag = RAND()
And you can get what you want.
You can download my test pbix file here
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I tried to create a DAX column 'Tag' Looks like,in Direct Query we can't create DAX column with value RAND()
Tag=RAND(). I get beloe error.
@anileshknpowerb , Create a new column
sum(Table[Revenue]) + Rand()
or
sumX(Table, Table[Revenue]) + Rand() )
and try. Other wise I doubt you can show.
You need add some unique column
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |