I am not able to find option to attached files here.
but here is solution.
Create calculated field : IF SUM([Count]) > 0 THEN "Yes" ELSE "No" END
use this to filter data by selecting Yes.
Also, you do not need parameter to select dates. you can use date field as filter with option Month / Year.
hope this helps.
UPDATE: Found way to attach. See Sheet 2.
Bar Graphs.twbx 22.3 KB
Your solution works but not when I use "Concate" Dimension. This is the dimension I need to use for the bar visualization. The purpose of "Concate" is there are situations where there are different version of a product with the same name. If I only use "Name" on the dimensions, it will sum up the total at the Product Name level (which is not my intention).
I also constructed a parameter because I want the users input to affect other visualizations I plan on adding to the final dashboard.
Hope this clears a few things. Really appreciate the assistance and hope you can help me solve this little problem.
I tried in using concat in the Sheet 2 of the workbook I attached and it works as expected.
Or may be I am missing something.
I also inserted Concat on Sheet 2 but it did not return the desired results.
As you can see here, the second product is still in view even though it does not have a sale in April. I would like to temporary remove that product from this view (date selected being April) because there are no records in the product. The good thing is that the last product was removed because it has no sales for April or March.
I want to create a measure that makes this action dynamic no matter what date was selected by the user.
but it does have sales in march. if you just select April, then you wont see product 2.
are you trying to hide all the products where event sales in month is zero?
Yes, I am trying to hide all products that have zero for the current month selected, regardless if they have sales on previous months. For example, Product 2 Model 1A t has no sales on April so it should not be in view if the current selected date is April. The current month sales is our identifier if the bar graph is in view or not.
If the user would have selected March, then Product 2 Model 1A would be in view because it does have sales for the Month of March. Product 2 Model 1A would also be in view if the user selected May because it does have sales in May even though it does not have sales in April.
If a product does have sales in the current month, I am trying to show the previous month sales so I can show a trend of sales operations.
I get it.
Try attached sheet. I used your parameter field to check which month user will select as current month.
small question: why do you want user to select current month. why don't you use TODAY() in calc fields?
Bar Graphs.twbx 22.0 KB
Awesome. These constructed variables are exactly what I was looking for. Thank you so much for your help.
I just have one more question, is there a way a user can manually change the y-axis implements manually? For instance, bar graph one has a y-increment of 2 while bar graph two has an increment of 5.
I figure that too since all these graphs are dynamic. Thank you so much for the help.
These metrics will help me construct dashboards that presents data in many different visualization and data depending on the users choice of month. Thank you so much for the assistance and apologies for the confusion throughout the feed. Really appreciate the quick response time.
No worries. Happy to help