Power BI Report using Google Analytics data

[Aman-K]

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?

[Aman-K]

I think I will need to add a measure to show data for last 30 minutes first. Can you help me with that please?

[Kedar_Pande]

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

[Aman-K]

Thanks @Kedar_Pande . Also how can I display the total active users as below

My Power BI report looks like this at the moment

[Kedar_Pande · Accepted solution]

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

[Kedar_Pande]

@Aman-K please share the sample pbix file

[rubayatyasmin]

Hi, @Aman-K 

try using sort by column option. choose the right column to sort. Try the way we use to display month column