Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I need to create a report based on this file. The report will have a date filter. When a user selects “March 1, 2019” The visualization will show Store 999 and Store 076 and not Store 456, because sales are 0 for that location in all categories.
So, something like SELECT Location WHERE Date=(Param) AND (Boot Sales IS NOT 0 AND Jackets Sales IS NOT 0 AND Pants Sales IS NOT 0)
What would be the best solution?
Thank you!
Solved! Go to Solution.
Hi @Anonymous ,
Please see the pictures below. First is a truncated table with some of your data. The second is a date slicer on the visual card. The picture also contains the measure I wrote using CALCULATE() and CONCATENEX().
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @Anonymous ,
I just rebuilt my measure again on a clean pbix to test and it still works.
Proud to be a Super User!
@Anonymous ,
Sorry, my miss read. If you use UNICHAR(10) with no quotes after the comma (instead of the ", ") it will create a list in a card.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
@Anonymous ,
Ok, this is cool. Created a second page, added a State column to my mockup table, put the map visualization on it on the new page, put the same table and filter on that page and filtered table for Total Sales greater than zero.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
BTW, I was able to solve the problem of displaying locations by simply using the Table visual instead of the Card. Used your original measure and it worked fine.
Hi @Anonymous ,
Please see the pictures below. First is a truncated table with some of your data. The second is a date slicer on the visual card. The picture also contains the measure I wrote using CALCULATE() and CONCATENEX().
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
@Nathaniel_C Thank you very much for the solution! Is it possible to show the Store values as a list, not as a string.
Like in the screen shot below.
Hi @Anonymous ,
I just rebuilt my measure again on a clean pbix to test and it still works.
Proud to be a Super User!
@Anonymous ,
Sorry, my miss read. If you use UNICHAR(10) with no quotes after the comma (instead of the ", ") it will create a list in a card.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
It does display it as a list now. But I have a couple of issues with it that I must solve: I can't scroll through it (I assume because it's a single row card) and I can't format it. So everything is centered. Another problem is that if a list is too long, then the last line just turns into a super long string.
Also, I have another visual on my report. it's a map showing states where those locations are. Driven by the same Date Slicer. Obviously now it goes by unfiltered location. Is there any way to apply your measure to that map to filter the results?
I am sorry to be a pain with all the questions 🙂
BTW, I replied to your message in the private Inbox. I hope it worked, as today I am having problems with my network and form loading in general.
@Anonymous ,
Ok, this is cool. Created a second page, added a State column to my mockup table, put the map visualization on it on the new page, put the same table and filter on that page and filtered table for Total Sales greater than zero.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Thank you so much for your help! I am going to try to figure it out and implement. I will report 🙂
Ana
@Anonymous ,
Still working on this, but this is down and dirty.
Proud to be a Super User!
BTW, I was able to solve the problem of displaying locations by simply using the Table visual instead of the Card. Used your original measure and it worked fine.
@Nathaniel_C Sorry for the confusion! I deleted my question about data type conversion (i did have an empty column with Text data type). I was able to fix it.
My other question was about how to display them in a list (like a multi-value card), instead of a string ( pls see my message above).
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |