Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Happy new year everyone!
I developed a dashboard that lets me analyse manufacturing data for multiple tests for a single client.
For example: Client A had 5 tests:
Each test (i.e. .xlsx file) contains multiple sensor readings indexed as a time series. For instance:
The main part of the dashboard was to compute maximums, averages, etc etc, for each test. I used a summarized table:
Summary_Tests =
Solved! Go to Solution.
Hi @Anonymous ,
Check the file attach with a transformation of the files for more than one client and without additional table for summarization.
The Source files are random numbers for each sensor I calculated in excel.
If you need any assistance please tell me.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
Not really sure if I understand your question, and the fact that you add a summarizing table to your model lost me.
Questions:
Without knowing the full setup of your model believe that your best option would be:
Can you please share a sample of your PBI and base files? If information is sensitive you can make a mockup or send it by private message.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi Felix,
It's hard to articulate the question.
I guess another way to put it is that a whole new variable (client) appeared at a higher level of everything I had. I cannot seem to find a simple way to filter it without ruining all the relationships, measurements, and calculated tables I already had.
The solution should be easy to replicate. Next week, I could have another variable thrown in next week (hopefully I won't), e.g. technology X, Y, Z. So I would hope I could have the same summary table showing the maximums for sensors 1 to 5 (always 5 sensors) for (Client A, Technology X) separetelly from (Client B, Technology X) and (Client A, Technology Y).
Let me tell you:
This is an oversimplified account of the model that I have, which was working. The issue again is that I'm having multiple "Test 1" when I have multiple clients.
Thank you!
Hi @Anonymous ,
As I refer believe that you are overcomplicating some part of the models and having additional table on the setup will introduce complexety and increase the issues on scaling.
Making use of the folder will allow you to have additional information taken out from the files (name, size, etc) that you can use to your advantage to create columns for your data not having the need to have more table and columns, or have manual inputs.
Also you need to make use of the dax and visualization based on the data in order to reduce the number of tables you have.
Question if I make some files based on the setup you have on the image of the first post will this be a correct representation of your model?
I will try to show you how I would setup this to be scalable to other requests.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
Check the file attach with a transformation of the files for more than one client and without additional table for summarization.
The Source files are random numbers for each sensor I calculated in excel.
If you need any assistance please tell me.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |