cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
hidenseek9 Helper V
Helper V

Visuals: Table exclude day from the view

Hi Power BI Community!

 

I have a question regarding a Table visuals.

I would like to see a revenue breakdown by categories (Row) and by monthly (Column)

Basically, I want to see revenue categories on the left hand side of the table and

I want to see month name on top right hand side of the column.

 

In raw excel data, I have dates (From 2017/1/1 to 2017/3/31) and I do not want to touch raw data.

When I put dates in the table visual column, it shows revenue by categories by day,

but I only want to see monthly view.

 

How can I filter out days and only look at monthly data?

 

PS. I use timeline visuals to select which months that the table will show. (This feature I want to keep)

 

Appreciate your support!

 

H

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
hidenseek9 Helper V
Helper V

Re: Visuals: Table exclude day from the view

Hi Power BI Community,

 

I created a column equaling date and then I was able to have a hierachy within dates to filter out day and quarter.

New Column = (Table(Dates))

 

No need for a response here!

 

Thanks,

 

H

 

 

 

 

View solution in original post

1 REPLY 1
hidenseek9 Helper V
Helper V

Re: Visuals: Table exclude day from the view

Hi Power BI Community,

 

I created a column equaling date and then I was able to have a hierachy within dates to filter out day and quarter.

New Column = (Table(Dates))

 

No need for a response here!

 

Thanks,

 

H

 

 

 

 

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors