cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chrisgreenslade
New Member

Help with Visualizations

Hi

 

I need to find a way to show accepted and rejected incidence that are linked to time.  I have a card which shows the total number for the month, but ideally I would like to see this information by day or week, using the slicer.

 

Also, the clustered bar chart (in the bottom left) is also showing this data for the entire month and not dynamically by day.

 

Any solutions would be great.

 

TableTableDashboardDashboard

5 REPLIES 5
V-lianl-msft
Community Support
Community Support

Hi @chrisgreenslade ,

 

Unfortunately, based on your description, there is no clear solution. It's better to let us know the data model and the expected results when you choose slicer.

If there is a relationship between the date table and the fact table, the result could be correct when you use slicers from the date table.

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

VijayP
Super User
Super User

I think you must use multicard with different attributes




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


This still doesn't work.

 

I have a multi-card in the top left of my dashboard (see image in thread), but this only shows the TOTAL amount and does not change when I change the date.

 

Similarly, the chart at the bottom left remains static for all days.  When I change the date, the chart in the bottom left updates but does not update the chart on the bottom right.

 

Chris

VijayP
Super User
Super User

@chrisgreenslade Try using this chart to show information separately 

VijayP_1-1610884597016.png

 

 

 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Thanks VijayP, but this is not really what I am after.

 

I just want all my data to sync accoriding to date, rather than show the toal for the month.  For example, if I look at 22nd Sept, I would like the number of accepted/rejected incidence to show that for the specific date.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!