Forum Discussion
Power BI Report using Google Analytics data
Hi All,
The Power bI report which I have craeted as below doesn't show minutes on Y axis in the descending order
I need the report to look like as below. Can you please advise what changes need to be made to get the below result?
Create a Measure to Count Entries Within the Last 30 Minutes
CountLast30Minutes =
COUNTROWS(
FILTER(
YourTable,
YourTable[Minutes] <= 30
)
)you can place it in a card visual to display the count of entries within the last 30 minutes.
Your Kudos/Likes are much appreciated!
If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.
Regards,
Kedar Pande
www.linkedin.com/in/kedar-pande
6 Replies
Hi, Aman-K
try using sort by column option. choose the right column to sort. Try the way we use to display month column
Aman-K please share the sample pbix file
I think I will need to add a measure to show data for last 30 minutes first. Can you help me with that please?
Create a new column:
IsWithinLast30Minutes =
IF(
YourTable[Minutes] > 30,
1,
0
)Now, apply a visual filter: Drag the IsWithinLast30Minutes column to the Filters pane and set it to show only 1
Thanks Kedar_Pande . Also how can I display the total active users as below
My Power BI report looks like this at the moment
